Hi all!

I just see the article on DBIx::Recordset and have the following question:
How would one build these SQL statements with DBIx::Recordset?

    INSERT INTO t1 VALUES (pkg_foo.get_bar, ?, ?, NULL, ?, ?, SYSDATE, ?,
seq_suck.nextval)

    UPDATE t2 SET c1 = c1 + 1, c2 = c3 + 2, c3 = c1 + 3 WHERE c4 = ?

Also, how does DBIx::Recordset deal with stored-procedures and cursors?

I never use this module before, and it seems to me that when the SQL becomes
more complicated,
the call to DBIx::Recordset->new() is as obfucated as the DBI call!
(Yes, I should then have the SQL hidden in stored-proc, but not every DB
supported that...)

Please enlighten me. Thanks,

Kenneth


Reply via email to