On Wed, Nov 21, 2001 at 01:22:27PM -0600, Tomasi, Chuck wrote: > Nevermind. I believe found the problem... When I put the values in to the > table, I never committed them. Once I added two or three more small test > cases, my original table started working. Strange how SQLPlus could access > the non-committed data, but Perl DBI could not.
This is only strange if you did not create the tables in the same sqlplus session (transaction). If you created the tables in sqlplus and then queried them, all will appear normal because both events occurred in the same transaction. Committing your transaction only makes things visible to others (like your Perl script); they are always visible within the same transaction. > Yes, I already checked, Perl DBI has AutoCommit ==> 1 in the connection > statement. > > --Chuck dd -- David Dooling
