Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] SQL Pass thru's not working in sit internal server but working in my local.
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] SQL Pass thru's not working in sit internal server but working in my local.
 Login/Join
 
Gold member
posted
I am having a situation and I dont know where it is going wrong.

This is my code

ENGINE SQLORA SET CONNECTION_ATTRIBUTES DEV/SIT TNS_NAME/USERNAME,PASSWORD

SQL SQLORA PREPARE SQLOUT FOR

SELECT * FROM S.TABLE WHERE CONDITION;

END

TABLE FILE SQLOUT
PRINT
*
END
-run


When I ran this code in my app stdio, pointed to sit it working good and when I ran code in Eclipse and pointed to sit with the same connections, it is showing segment not found error.
I use schema.tablename properly.


When I use master files there is no problem at all.
Database:Oracle.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 56 | Registered: February 02, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
-run should be switched to uppercase -RUN.

Also, could you explain again what you mean by ran code in Eclipse? The full text of the error message would be very helpful as well. Segment not found should tell you what segment it's looking for that it didn't find.


WebFOCUS 8204, Unix, Windows
 
Posts: 1528 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
This was the error message :

(FOC1400) SQLCODE IS 903 (HEX: 00000387)
: ORA-00903: invalid table name
: Erroneous token: table
L (FOC1405) SQL PREPARE ERROR.
0 ERROR AT OR NEAR LINE 63 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SQLOUT
BYPASSING TO END OF COMMAND

We integrate the WebFOCUS code with java code and run it from the web applications like oracle weblogics or ibm websphere.


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 56 | Registered: February 02, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
pav

This is definitely not a WebFOCUS issue, it is a message directly from Oracle saying it doesn't like the table name used in the request. Does it work from SQLPLUS?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1430 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Oh.
I did't tried sqlplus. well, I will try that and get back to you.

Thanks for the reply chuck.


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 56 | Registered: February 02, 2016Reply With QuoteReport This Post
Gold member
posted Hide Post
quote:
SQLPLU


The same query working great in other tool including AQT also.

I have tried on table hold as hold_name format sqlora but no luck still facing the error.


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 56 | Registered: February 02, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Pav

Better open a case with techsupport on this one.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1430 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi,
Could you change the connection string to
ENGINE SQLORA SET DEFAULT_CONNECTION [Connection Name]

then try. I have seen this in the past where
"ENGINE SQLORA SET CONNECTION_ATTRIBUTES" fails to connect.

All the best


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Gold member
posted Hide Post
I opened a case with ibi and at the same time I will try you suggestion addy and let you know soon.

Thanks for your inputs.


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 56 | Registered: February 02, 2016Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks Addy, it worked and IBI also mentioned the same solution.


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 56 | Registered: February 02, 2016Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] SQL Pass thru's not working in sit internal server but working in my local.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.