Hi, Thomas. The following is a very simple dbproc:
CREATE DBPROC TEST1 AS SAVEPOINT SP; ROLLBACK TO SP; When I execute it in sqlstudio. It does't work! The sqlstudio prompts me the following message. --- Error ------------------------------- Auto Commit: On, SQL Mode: Oracle, Isolation Level: Committed Syntax error or access violation;-5015 POS(27) Missing keyword:RETURN,FETCH,EXECUTE,CLOSE,CALL,WHILE,SET,SELECT,IF,D. CREATE DBPROC TEST1 AS SAVEPOINT SP; ROLLBACK TO SP; Would you mind help me to solve this problem? Thx. Regards, Lucas _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
