OLEDB - SqlPLSQLCommand problem

forum.connectivity (2000-2005) & forum.td.connectivity (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 115421
Joined: 24 Feb 2017, 12:00
Location: World wide

OLEDB - SqlPLSQLCommand problem

Post by NewsgroupServer » 21 Oct 2008, 18:21

 Posted by:  Thomas Lauzi 

Hi,

I switched my application (TD4.2) from native routers to OLE DB.
I removed all SqlImmediates, because I know, that they are not supported
anymore
I use SQLUDL = "''Provider=OraOLEDB.Oracle.1''" and everything runs smooths,
except SqlPLSqlCommand.

I get a weird error when executing SqlPLSQLCommand(...).
The error is:

Not a PL/SQL oracle database.
Halt application?

I thought it is compatible with OLEDB. Is the function also deprecated and
must be replaced??

Regards,
Thomas L.

NewsgroupServer
Robot
Robot
Posts: 115421
Joined: 24 Feb 2017, 12:00
Location: World wide

OLEDB - SqlPLSQLCommand problem

Post by NewsgroupServer » 21 Oct 2008, 19:52

 Posted by:  Krzysztof Dorko 

Hi
I will try "SqlPrepareSP" Instead of. I am not an expert in Oracle, but
according to the help it is good function to run with oledb and it is
working with Oracle.
I had similar problem with MSSQL and now I have to recognize connection type
(oledb/odbc) before run any stored proc.

hth
Kris

NewsgroupServer
Robot
Robot
Posts: 115421
Joined: 24 Feb 2017, 12:00
Location: World wide

OLEDB - SqlPLSQLCommand problem

Post by NewsgroupServer » 22 Oct 2008, 10:33

 Posted by:  Thomas Lauzi 

Hi,

I saw in the SqlRouter/Oracle to OLE DB whitepaper, that "SqlPrepareSP" is
recommended and SqlPLSQLCommand is not supported anymore.
This means a massive code replacement and a lot of work for us...
Is no older function like SqlPLSQLCommand or SqlOraPLSQLPrepare working
anymore with OLE DB?
->I want a function, that work with both, native routers and OLE DB!!

Regards,
Thomas L.

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests