Error when using SQL*Plus @@ command in SQL Navigator
When I try to use the @@ SQL*Plus command in a script I get the message “ORA-00936: missing exppression!” when it reaches the line containing this command. I read the help and they say that the @@ command is admitted. I’ve tried the same script in Oracle Enterprise Manager Console->Tools->Database->Applications->SQL*Plus Worksheet and it worked.

Answer Question   |  May 12, 2009  10:22 AM
ORA-00936, Oracle Enterprise Manager, Oracle error messages, SQL, SQL Navigator, SQLPlus

Error calling APPS.AR_ADJUST_PUB.Create_Adjustment
Calling this API from SQL Navigator and working on a Release 12 implementation. This is the error message: ORG ID is required. I’m setting all this in the begining, but still I get the message. apps.fnd_global.apps_initialize(1154, 20678, 222); APPS.ARP_GLOBAL.INIT_GLOBAL; FND_MSG_PUB.Initialize; dbms_application_info.set_client_info(81); apps.Fnd_Client_Info.Set_Org_Context(81); Any clue?

Answer Question   |  August 21, 2008  3:32 PM
API, SQL Navigator