Hello,

I see that I should declare stored procedure,
when it's first parameter is in out parameter.

I have Oracle 9i.
I have Crystal 9.

I have a problem., when running,
I get the message : ORA-01002.

The procedure, I use in crystal :
CREATE OR REPLACE procedure TEST_GEN(p_cur in out s_general.cur_int, p_int1
in varchar2) is

cur_ref s_general.cur_int;

begin

open p_cur for

select p_int1 from dual;

end;

/



The s_general package :

CREATE OR REPLACE package S_GENERAL is

rep_last_date date;

dummyInt number;

TYPE cur_int IS REF CURSOR;

end package;


Why is the above ORA-01002 problem ?

Thanks

Did you look up the ora-1002 error?
No? Here is the link to it
http://www.oracle.com/pls/db92/db92....earch=ORA-1002

Did you look up the syntax for OPEN FOR?
Undoubtedly not! Otherwise you wouldn't have mixed up dynamic and
static SQL.

Do you really plan to develop in a NUISANCE for this forum with all of
your RTFM questions?
Probably!

Please go away here, try to be less lazy, and don't come back here
until you have done *your* homework!!!

No Regards at all
--
Sybrand Bakker
Senior Oracle DBA

Oh,
You ran out of words, so you start spelling.
Instead of spelling and shouting and raising hands,
you can simply give simple answers to simple questions.
I suppose you go out of here
(As your words, it's seems that you are a kid, so don't bla bla ...)

Please, no matter who is lazzy,
newsgroup is a way getting answers,
and millions can answer.
It it the first time, since years I see answers like yours.

I have a problem in my code above (ORA-01002),
I didn't find out what
why not just tell me what the problem is ?

Thanks

On Mon, 15 May 2006 16:01:57 +0200, "Eitan" <nospam@nospam_please.com>
wrote:

>Oh,
>You ran out of words, so you start spelling.
>Instead of spelling and shouting and raising hands,
>you can simply give simple answers to simple questions.
>I suppose you go out of here
>(As your words, it's seems that you are a kid, so don't bla bla ...)
>
>Please, no matter who is lazzy,
>newsgroup is a way getting answers,
>and millions can answer.
>It it the first time, since years I see answers like yours.
>
>I have a problem in my code above (ORA-01002),
>I didn't find out what
>why not just tell me what the problem is ?
>
>Thanks
>

Your problem is you either don't read manuals, or you don't read them
closely enough, and immediately you run whining to this newsgroup in
order to be spoon fed.
Actually I did provide you with the answer, but as you seem to be
unable to read it, I will repeat it here:
Open for requires *DYNAMIC* sql.
Now you go to the PL/SQL reference manual, read the section on OPEN
FOR closely, and answer your own question.

Please note that next time when you have a similar question I won't
respond, and likely will no one. This is not a place for people who
are too lazy to RTFM.

--
Sybrand Bakker, Senior Oracle DBA