Skip to content

Instantly share code, notes, and snippets.

@ronnysuero
Last active August 29, 2015 14:08
Show Gist options
  • Save ronnysuero/e7ee7831b3f6fac7ba03 to your computer and use it in GitHub Desktop.
Save ronnysuero/e7ee7831b3f6fac7ba03 to your computer and use it in GitHub Desktop.
set SERVEROUTPUT on size 100000;
DECLARE
VARIABE NUMBER;
BEGIN
VARIABE := IMPORTAR_PAISES_PKG.GUARDAR_PAISES( 26, 1, 'PRUEBA PARAM 1', 'PRUEBA PARAM 2', 1, 1 );
dbms_output.put_line(VARIABE);
END;
DECLARE
VAR NUMBER;
BEGIN
SELECT NOTA_ID
INTO VAR
FROM NOTAS
WHERE NOTA_ID = 2;
DBMS_OUTPUT.PUT_LINE(VAR);
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment