Please advise:
Environment NT, Perl 5.6, Oracle 8.1.7
True64, Perl 5.5, Oracle 8.1.5
Intend to populate a table from the Web (table contains beside others some 10 columns each varachar2(500) ).
I would like to do a single DBI connection, call a stored procedure and send there all data of the total size max. 6k
1/ Is there a limitation on the size of the data which could be send via DBI ?
If yes, how much (in that case obviously the insert will be done on few columns and followed by updates)
2/ Could one do interMedia type queries using DBI as any other standard SQL statements
(i.e. select ... where CONTAINS ...) ?
3/ Are there available XML modules for both NT and Unix which could transform variables into a single variable containg full XML document (based upon provided DTD) ?
Thanks
peter
Environment NT, Perl 5.6, Oracle 8.1.7
True64, Perl 5.5, Oracle 8.1.5
Intend to populate a table from the Web (table contains beside others some 10 columns each varachar2(500) ).
I would like to do a single DBI connection, call a stored procedure and send there all data of the total size max. 6k
1/ Is there a limitation on the size of the data which could be send via DBI ?
If yes, how much (in that case obviously the insert will be done on few columns and followed by updates)
2/ Could one do interMedia type queries using DBI as any other standard SQL statements
(i.e. select ... where CONTAINS ...) ?
3/ Are there available XML modules for both NT and Unix which could transform variables into a single variable containg full XML document (based upon provided DTD) ?
Thanks
peter