Michael Peppler [MP], on Friday, April 29, 2005 at 17:55 (+0200)
contributed this to our collective wisdom:
MP No - just do a select @@identity to get the latest value.
ok, that's the way too, I totally forget about @@identity.
thanks.
--
How do you protect mail on web? I use
I upgraded to MacOS X 10.4 Tiger on Friday evening. Now, I'm having
problems with my Perl 5.8.6 (both the version I built on Panther and a
new build done on Tiger) accessing CPAN sites. Nothing using just
Perl works, nor using a (possibly archaic) wget from /sw/bin (fink -
Oracle supports the use of select list expressions of type REF CURSOR.
These may be explicit cursor expressions - CCURSOR(SELECT ...), or
calls to PL/SQL functions which return REF CURSOR values. The values
of these expressions are known as nested cursors.
DBD::Oracle-1.16 does not support queries
I am running a postgresql database and am finding that DBI is returning
the wrong data type for the postgresql DATE type. Here is some example
code:
snip - connection info/
my $sql = SELECT birthdate, points, username FROM _users WHERE user_id
= 27;
my
Mark Vaughan wrote:
Amonotod,
Yes, that helped tremendously.
Now I've moved on to the next problem.
I installed unixODBC and the tsql command worked (no errors), although
it replied with a 1 prompt and didn't seem to do anything unless I
typed 'quit', in which case it did just that.
I was able to
Perl experts,
I've got DBI and Apache configured to connect to an Oracle 9.2 database.
I'm considering upgrading the database to 10g.
Not expecting any problems but if anyone has gone that route and are
willing to share any gotchas or additional suggestions i'd certainly
appreciate it.
Thanks,
I managed to answer my own question. I figure if I write it up the next
person searching for a clue can find the answer instead of just the
question.
Apparently the return value(s) from executing SQL in SQL Server is/are
'side effects' of certain SQL commands (e.g. INSERT or UPDATE).