> -----Original Message----- > From: Jackson, Harry [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 9:35 AM > To: '[EMAIL PROTECTED]' > Subject: Perl DBI and Oracle > > > Ho do you > > set linesize 1000; > > using dbi for Oracle. I have tried inserting it before the "select" > statement and putting it in its own "prepare" statement but > neither have > worked. Google has got very little on this when I searched > for it. I would > appreciate a decent link to how to do this sort of thing.
"set linesize" is a SQL*Plus commmand. The database knows nothing about "set linesize". DBI talks directly to the database engine, so only Oracle SQL statements are understood. Why are you wanting to issue a "set linesize" command? It's the responsibility of your script to format the output appropriately; DBI can't help with that. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]