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!
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/