Oracle 8.x calling Oracle Stored procedures (OpenInsight 16-Bit Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 19 JUN 2002 03:45:25AM Kyle Amadio wrote:

OpenInsight 16-Bit Specific

I can successfully call an Sybase Stored Procedure via the CS Query tool - EG : EXECUTE int_who - works fine. However using the 16BIT Oracle driver I get an "ORA-00900 Invalid SQL Statement".

I tried

SCRIPT=EXECUTE "

and

EXECUTE

and

"EXECUTE "

and get the same result

Any ideas ?

At 19 JUN 2002 06:07AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Kyle,

Can't say I'm an Oracle expert but try using 'exec' instead of 'execute'?

The Sprezzatura Group

World leaders in all things RevSoft

At 19 JUN 2002 07:13AM Kyle Amadio wrote:

Thanks - however EXEC and EXECUTE give the same result - its got something to do with the way Oracle receives the STRING AND then tries to execute it. We have a Oracle Admin tool called TOAD and it has two modes to talking to the Oracle Server - one is direct and the other is SCRIPT mode. If we use the Direct mode we get the same error as we get out of OI ORA-00900. If we use the SCRIPT mode it works.

Rev suggested that the command be sent as

SCRIPT=EXECUTE proc name" - but that failed also.

At 19 JUN 2002 12:00PM dsig@teleport.com wrote:

As an aside .. have you tried this with 32bit?

dsig@teleport.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 503-639-4240

At 19 JUN 2002 07:04PM Kyle Amadio wrote:

No Not yet - will give it a try - Does the 32BIT Oracle Direct Interface work ?

Or only the 32 ODBC…

At 20 JUN 2002 03:40AM Kyle Amadio wrote:

This is how we got it work

TEST_PEND is an Oracle Stored Proc with one argument

OrderNo=2000

Script= "BEGIN TEST_PEND(":OrderNo:"); END;"

IsValid=QryMethod(hQry, QRY_EXECUTE$, script,,IsResult,,'')

Err=QryMethod(hQry, QRY_GETERROR$, A1,A2,A3,A4,A5)

At 21 JUN 2002 10:14AM dsig@teleport.com wrote:

I have to say that I have had nothing but problems with OI32 and odbc. Have passed much info to Pat at rti and dont know the results. I have changed my presentation to the conference from odbc and MySql to native Ms Sqlserver just to get it all working .. which makes me very sad as the original was written against Oracle native and ODBC

So .. don't have an answer for you. If you do try OI32 against oracle let me know if you have any problems with procedures

dsig@teleport.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 503-639-4240

View this thread on the forum...