Creating Oracle Stored Procedures in VB?
Rob,
The ADOX model promises this in the future by using the Append
method of the Procedures collection. Unfortunately, it does not
currently work with Oracle. You may try saving the information to disk
and running it as a script by shelling out to SQL*Plus, but this is not
the solution you were looking for. Sorry!
Kirk Allen Evans
Quote:
> I need to be able to create Oracle Stored Procedures through a VB
app. I am
> currently doing this by reading the script for the SP into a big
string.
> Then I execute the string using RDO's execute method. This works
fine and
> dandy for strings less than 32K. Unfortunately anything over 32K
causes an
> error - something about length of SQL string is too long. I am
pretty sure
> there is a 32K ODBC limitation on the length of SQL string that can be
> executed using the SQLExecDirect function. RDO is just a thin layer
above
> ODBC, so an ODBC limitation is an RDO limitation.
> Does anyone know a way around this problem, other than creating the
SPs
> manually through SQL*Plus?
--
Kirk Allen Evans
(Do not send mail to the Deja News account used
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
