please help
create or replace package abc_pack as
type rctl is ref cursor;
end;
CREATE OR REPLACE procedure sp_PROC(CODE IN CHAR,
rc1 in out abc_pack.rctl) is
begin
IF CODE IS NULL THEN
open rc1 for select table_CODE,DESCN from table1;
Else
open rc1 for select table_CODE,DESCN from table1 where table_code=code;
End if;
end sp_PROC;
then i go to crystal 6 select new/standard/ sql/odbc
select the server and select the procedure
when i select the procedure i prompts for in to value for code and cursor .this doesn't allow me to give null value for any of the thing.where have igone wrong and is there any file that i have to install .
i am using only oracle 7.3 and crystal 6.i have not installed or downloaded any files.
please help.
create or replace package abc_pack as
type rctl is ref cursor;
end;
CREATE OR REPLACE procedure sp_PROC(CODE IN CHAR,
rc1 in out abc_pack.rctl) is
begin
IF CODE IS NULL THEN
open rc1 for select table_CODE,DESCN from table1;
Else
open rc1 for select table_CODE,DESCN from table1 where table_code=code;
End if;
end sp_PROC;
then i go to crystal 6 select new/standard/ sql/odbc
select the server and select the procedure
when i select the procedure i prompts for in to value for code and cursor .this doesn't allow me to give null value for any of the thing.where have igone wrong and is there any file that i have to install .
i am using only oracle 7.3 and crystal 6.i have not installed or downloaded any files.
please help.