creating stored procedure Query subject

[irvingbos]

Hi, anyone with experience in creating an SP to insert data to a table in Oracle? 

I have one set up in FM, everytime I validate it, it reports RQP-DEF-0177 An error occurred while performing operation 'sqlExecute' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "execute".

It DOES insert the data to the table, so I am not sure what the error means.

here is the SP code:
CREATE OR REPLACE PROCEDURE sp_insert_TELEMETRICS (
   p_LOGIN_ID    IN     VARCHAR,
  p_recordset OUT SYS_REFCURSOR

)
AS
BEGIN
   
   INSERT INTO DF_TELEMETRICS (LOGIN_ID)
     VALUES   (p_LOGIN_ID);

   COMMIT;


END sp_insert_TELEMETRICS;

any suggestions would be appreciated!

[irvingbos]

UPDATE:  sorted in out, needed "open p_recordset  for   select 1 from dual" ; after the commit.so the recordset contains something. Can clean it up to show a real result, but now i have a skeleton.  (thanks to CognosPaul for old blog entry on this subject) https://cognospaul.wordpress.com/about/