Howdy,
So, I've got these heavy duty, complicated T|PL-sql scripts, that I have to pass
through to my DB, after I finish populating it. They come complete with temporary
tables, EXEC statements, stored procedure create/drop statements, select into's,
nested cursors and procedures, you name, I'm using it. Right now, I'm trying to get
the T-SQL script to run in MS SQL 2K, and it's failing with various errors. I've
tried both do() and prepare()/execute, with no success. prepare()/execute gives me:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
(SQL-24000)(DBD: dbd_describe/SQLN
umResultCols err=-1) at D:\development\dbd_db.pl line 487, <QUERY> line 165.
and do() gives no error, but does not seem to have succeeded in populating this last
lookup table that the script is supposed to create...
So, any pointers, advice are appreciated...
Thanks,
amonotod
--
`\|||/ amonotod@ | sun|perl|windows
(@@) charter.net | sysadmin|dba
ooO_(_)_Ooo____________________________________
_____|_____|_____|_____|_____|_____|_____|_____|
