Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from Oracle to GaussDB/ U0100084: GaussDB does not support DBMS_SQL.TO_CURSOR_NUMBER
Updated on 2026-03-19 GMT+08:00
View PDF
Share

U0100084: GaussDB does not support DBMS_SQL.TO_CURSOR_NUMBER

Description

In Oracle, DBMS_SQL.TO_CURSOR_NUMBER is used to obtain a cursor number. GaussDB does not support this function.

Database Type and Version

  • Source database type and version: Oracle versions supported by UGO
  • Target database type and version: GaussDB versions supported by UGO

Syntax Example

DECLARE
  l_ref_cur SYS_REFCURSOR;
  l_dbms_sql_cursor NUMBER;
BEGIN
   OPEN l_ref_cur FOR SELECT 'Hello, DBMS_SQL!' AS message FROM dual; 
   l_dbms_sql_cursor := DBMS_SQL.TO_CURSOR_NUMBER(l_ref_cur);
  DBMS_SQL.CLOSE_CURSOR(l_dbms_sql_cursor);
END;
/

Suggestion

Comment out DBMS_SQL.TO_CURSOR_NUMBER and use DBE_SQL.REGISTER_CONTEXT, DBE_SQL.SQL_SET_SQL, and DBE_SQL.SQL_RUN.

Syntax compatible with GaussDB:

DECLARE
  l_ref_cur SYS_REFCURSOR;
  l_dbms_sql_cursor NUMBER;
BEGIN
  OPEN l_ref_cur FOR SELECT 'Hello, DBMS_SQL!' AS message FROM dual;
    --l_dbms_sql_cursor := DBMS_SQL.TO_CURSOR_NUMBER(l_ref_cur);
   l_dbms_sql_cursor := DBE_SQL.REGISTER_CONTEXT();
   DBE_SQL.SQL_SET_SQL( l_dbms_sql_cursor,l_ref_cur,2);
   DBE_SQL.SQL_RUN( l_dbms_sql_cursor);
   DBE_SQL.SQL_UNREGISTER_CONTEXT(l_dbms_sql_cursor);
END;
/