Can someone please tell me...

[Paul Clement]

¤ 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)

 

[Guest]

Personally I try to avoid stored procedures so our app can be easily moved
between database vendors.

 

[Matt Noonan]

Not a problem! ;-)

BEGIN
SELECT EMPSEQ.NEXTVAL INTO :EMPLOYEE_ID FROM DUAL;
INSERT INTO EMPLOYEES (EMPLOYEE_ID, etc.) VALUES EMPLOYEE_ID, etc.);
END

 

[Matt Noonan]

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...