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

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

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 (AT) nospam_please (DOT) com>
wrote:

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