We help IT Professionals succeed at work.
Get Started

Help Calling Oracle Stored Proc

Robb Hill
Robb Hill asked
on
923 Views
Last Modified: 2013-12-19
I am a Sql Server guru..but please help on the Oracle side..

Using Golden version 6 to call a stored procedure....and just cannot get the syntax down to call it.
Here is the stored proc definition

I need to know how to call this from within golden..

and then im wiring it into a .net datasource control...I will make that part a separate post if I still have issues.
Procedure GetOrgNames (tOrgCursor In Out OrgRefCursor)
is
begin
	open tOrgCursor for
	Select 0 ID,'<Select Organization>' Text from Dual
	union
	select OrgID ID, OrgName Text from organization order by Text;
end GetOrgNames;

Open in new window

Comment
Watch Question
Deputy General Manager - IT
Commented:
This problem has been solved!
Unlock 3 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE