Re: using in crystal - 05-15-2006 , 07:24 AM
Did you look up the ora-1002 error?
No? Here is the link to it
Did you look up the syntax for OPEN FOR?
Undoubtedly not! Otherwise you wouldn't have mixed up dynamic and
Do you really plan to develop in a NUISANCE for this forum with all of
your RTFM questions?
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
Senior Oracle DBA
using in crystal - 05-15-2006 , 07:53 AM
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
open p_cur for
select p_int1 from dual;
The s_general package :
CREATE OR REPLACE package S_GENERAL is
TYPE cur_int IS REF CURSOR;
Why is the above ORA-01002 problem ?
Re: using in crystal - 05-15-2006 , 09:01 AM
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 ?
Re: using in crystal - 05-15-2006 , 12:31 PM
On Mon, 15 May 2006 16:01:57 +0200, "Eitan" <nospam (AT) nospam_please (DOT) com>
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