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,

-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.

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.

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?

Oh.
I did't tried sqlplus. well, I will try that and get back to you.

Thanks for the reply chuck.

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.

Pav

Better open a case with techsupport on this one.

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

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.

Thanks Addy, it worked and IBI also mentioned the same solution.