sql.get_sqnc_nmbr.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of cloudgraph-rdb Show documentation

CloudGraph(tm) is a suite of Service Data Object (SDO) 2.1 services designed for relational and big-table style "cloud" databases, such as HBase and others.

The newest version!

CREATE OR REPLACE PROCEDURE "GET_SQNC_NMBR" (sqnc_nm IN VARCHAR2,
sqnc_nmbr OUT NUMBER
)
AS
   sql_stmt    VARCHAR2 (200);
   sql_stmt2   VARCHAR2 (200);
BEGIN
   sql_stmt := 'SELECT ' || sqnc_nm || '.nextval' || ' ' || ' from dual';

   EXECUTE IMMEDIATE sql_stmt
   INTO              sqnc_nmbr;
EXCEPTION
   WHEN OTHERS THEN
      raise_application_error (-20102, 'Sequnce ' || sqnc_nm || ' does not exist.');
END;
/