Oracle Stored Procedure in Cognos FM????

[sconti11]

I have been working on this project on and off for a few weeks now...and I know I am at my wits end!

So what I am trying to do is create an Oracle stored procedure that will allow for in parameters and 1 out parameter. The procedure compiles fine, and looks good when running in SQL Developer, but as soon as I import it into FM, i see errors. I found out through the IBM knowledge base that in order for an Oracle SP to be successful within FM, it needs to be within a package. Yet, for some reason I am unable to locate this procedure that is within the package??? So the code below is the package specs and body...and the error that I am attaching as well is related to just the SP that is using the OUT variable from the package:

create or replace PACKAGE pk_comments as 
TYPE t_comment IS RECORD( 
p_member_id sc_comment_test.member_id%TYPE, 
p_member_lastname sc_comment_test.member_lastname%TYPE, 
p_member_firstname sc_comment_test.member_firstname%TYPE, 
p_member_startdate sc_comment_test.member_startdate%TYPE, 
p_member_enddate sc_comment_test.member_enddate%TYPE,
p_product_cat_code sc_comment_test.product_cat_code%TYPE,
p_comment sc_comment_test.comments%TYPE); 
TYPE t_comment1 IS REF CURSOR RETURN t_comment; 
end;
/
create or replace package body PK_COMMENTS as
PROCEDURE insertCognosComment( 
p_member_id IN sc_comment_test.member_id%TYPE, 
p_member_lastname IN sc_comment_test.member_lastname%TYPE, 
p_member_firstname IN sc_comment_test.member_firstname%TYPE,
p_member_startdate IN sc_comment_test.member_startdate%TYPE,
p_member_enddate IN sc_comment_test.member_enddate%TYPE,
p_product_cat_code IN sc_comment_test.product_cat_code%TYPE, 
p_comment IN sc_comment_test.comments%TYPE default null, 
result1 OUT PK_COMMENTS.t_comment1) 
IS 
BEGIN 
INSERT 
INTO SC_COMMENT_TEST( 
member_id, 
member_lastname, 
member_firstname,
member_startdate,
member_enddate,
product_cat_code, 
comments
) 
VALUES( 
p_member_id, 
p_member_lastname,
p_member_firstname,
p_member_startdate,
p_member_enddate,
p_product_cat_code,
p_comment); 
commit; 
OPEN result1 FOR SELECT * FROM sc_comment_test; 
END;
END;

As i stated, once I import this into FM and attempt to validate i get the following errors in this order:

1) XQE-PLN-0245 The value 'NULL' is unacceptable for parameter 'null'
2) XQE-DAT-0001 Data source adapter error: java.sql.SQLException: ORA-06550: line 1, column 8:
PLS-00201: identifier 'INSERTCOMMENT' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
- when processing query: CALL "SCONTI"."INSERTCOMMENT" (
null,
null,
null,
null,
null,
null,
null
).

I hope that someone will be able to point me in the right direction.

Thanks in advance