Can someone please tell me...

  • Thread starter Thread starter Guest
  • Start date Start date
¤ Really? I do it all the time. :)
¤

Yes, I've never had to do it, but I didn't say you couldn't. ;-)

He was asking about Oracle though so you're going to have to change your code a bit. ;-)


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Personally I try to avoid stored procedures so our app can be easily moved
between database vendors.
 
Not a problem! ;-)

BEGIN
SELECT EMPSEQ.NEXTVAL INTO :EMPLOYEE_ID FROM DUAL;
INSERT INTO EMPLOYEES (EMPLOYEE_ID, etc.) VALUES (:EMPLOYEE_ID, etc.);
END
 
Which is a difficult challenge, even when you're talking about Access and
SQL Server. Getting schemas to match between vendors is the primary
obstacle, and it makes writing portable parameterized queries difficult.

Even with the Enterprise Library... :-)
 
Back
Top