[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:DEC ODBC Driver
Notice:DEC ODBC Driver V2.0 Now Available
Moderator:SQLSRV::MAVRIS
Created:Tue Dec 29 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1357
Total number of notes:4864

1345.0. "call stored procedure from powerbuilder" by b-w006.be.oracle.com::AROELANT () Thu May 22 1997 09:11

Hello All,


My customer is having trouble with calling stored procedures from within
Powerbuilder via ODBC V2.1 32 bit.

all ok via 16 bit driver (same powerbuilder executables)

with 16 bit driver (on a win 3.11 PC):
ROUTINE LEVEL LOG
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 46, value: call PROD_GET_FREE_PRDNUM  ('000500' ,?      )

with 32 bit driver (Win 95):
ROUTINE LEVEL LOG at 08:24:45 on 21-May-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 49, value: call PROD_GET_FREE_PRDNUM  ('000500' ,'' OUTPUT )

Any ideas??
Andre.
T.RTitleUserPersonal
Name		DateLines
1345.1M5::JBALOGHThu May 22 1997 12:365
    Is this resulting in a syntax error? Have you defined ProcOutParams and
    other definations specific to powerbuilder as outlined in the ODBC 
    readme.txt file?
    
    John
1345.2Maybe...b-w006.be.oracle.com::AROELANTFri May 23 1997 06:477
Well John,

he thinks he did but he will verify again...

Thanks,

Andre.
1345.3procoutparams in rdbodbc.ini/win.inib-w006.be.oracle.com::AROELANTTue May 27 1997 06:067
Ok now,

sqrdb.txt says ProcOutParms has to be set in win.ini but for the 32 bit driver
this should be in rdbodbc.ini....

Thanks,
Andre.