Calling an Oracle SP that is in a package

[WP]

Hi,

I have a SP that is in a Package and need to call it from VB.

What I have so far is calling a SP that's not in a package :

OracleSPCall.CommandText = "WS_OLY_Reset"
OracleSPCall.CommandType = adCmdStoredProc
OracleSPCall.Execute

Can someone tell me the syntax for calling a Procedure in a package.

Thanx

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[chiph]

Bill -

What user are you connecting to the database as? IIRC, access to a package is usually limited to the user who created it.

Chip H.

 

[culshaja]

You need to use the format package_name.procedure_name

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305