Advertisement

10.12.2006 at 01:51PM PDT, ID: 22022720
[x]
Attachment Details

TOAD, SQL Editor, and EXEC'ing a Stored Procedure?

Asked by lisfolks in Oracle 3rd Party Tools

Tags: toad, procedure, stored, sql

I'm using TOAD for Oracle.  I'm trying to execute a stored procedure with two parameters - one IN and one OUT.  It looks like this:

   PROCEDURE get_stuff (
      parm_1   IN       VARCHAR2,
      parm_2   OUT      currefcursor)

In the SQL Editor window in TOAD, I've tried various things to no avail.  I'm sure this is something simple that I'm missing, 'cause I've tried all sorts of things I've seen in other solutions here at Experts Exchange, but can't get past various errors.  Here's what I think should work from what I've seen here:

     var p1 VARCHAR2 := 'some text';
     var p2 currefcursor;
     
     EXEC get_stuff( :p1, :p2 );

When I run this, though, the SQL Editor pops up a window titled 'Variables' that appears to be looking for a value.  No matter whether I put something in the 'Value' textbox or not, when I click OK, it says:

    ORA-00900: invalid SQL statement

and highlights the 'var' in front of p1.

Please tell me what I'm missing!Start Free Trial
 
Keywords: TOAD, SQL Editor, and EXEC'ing a …
Title
1 toad
2 Spooling in Toad
3 Quest, Toad, 8.5.3.2
4 Oracle, retrieving output from stored …
5 Data displaying outside of viewable wi…
6 checking locking in oracle with toad
 
Loading Advertisement...
 
[+][-]10.12.2006 at 04:31PM PDT, ID: 17720294

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.12.2006 at 04:42PM PDT, ID: 17720331

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.12.2006 at 04:44PM PDT, ID: 17720335

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.12.2006 at 04:56PM PDT, ID: 17720365

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.13.2006 at 12:46AM PDT, ID: 17722053

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]10.13.2006 at 02:34AM PDT, ID: 17722415

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.13.2006 at 02:46PM PDT, ID: 17727940

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.13.2006 at 02:49PM PDT, ID: 17727964

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.16.2006 at 03:35AM PDT, ID: 17737567

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.16.2006 at 08:17AM PDT, ID: 17739529

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.16.2006 at 08:29AM PDT, ID: 17739646

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.17.2006 at 06:37AM PDT, ID: 17747470

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]10.17.2006 at 02:51PM PDT, ID: 17752567

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.17.2006 at 04:52PM PDT, ID: 17753166

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle 3rd Party Tools
Tags: toad, procedure, stored, sql
Sign Up Now!
Solution Provided By: drs66
Participating Experts: 3
Solution Grade: A
 
 
[+][-]10.17.2006 at 05:09PM PDT, ID: 17753243

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.18.2006 at 12:04PM PDT, ID: 17759625

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.19.2006 at 01:31AM PDT, ID: 17764018

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.19.2006 at 08:51PM PDT, ID: 17771424

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32