{{theTime}}

Search This Blog

Total Pageviews

How to run functions in Oracle using Aqua Data Studio:

DECLARE
TYPE REFCURSOR IS REF CURSOR;
RETURN_VALUE REFCURSOR;
ID VARCHAR2(2000) := 'ID';
BEGIN
RETURN_VALUE := db.PKG_ID_CHAN.function1(ID);
DBMS_OUTPUT.PUT('ID: ');
DBMS_OUTPUT.PUT_LINE(ID);
END;
GO

No comments:

Windows 8.3 file naming setting is disabled for the product

To enable Windows 8.3 file naming setting use fsutil command Example:  c:\> fsutil 8dot3name set C: 0