I have a PHP functi开发者_如何转开发on that calls a PL/SQL package that can throw a number of known exceptions (i.e. user exceptions) that I can catch in PHP and act on. The problem is, despite catchi
This question already has answers here: Closed 11 years ago. Possible Duplic开发者_如何转开发ate:
I have written pl/sql script (works, but doesn\'t look nice): DECLARE v_exists NUMBER; BEGIN SELECT count(*) INTO v_exists FROM dba_tablespaces WHERE tablespace_name = \'hr_test\';
I would like to be able to print out all results for a query (that should be filtered by the PK from TableA) and do this for each PK in TABLEA.
Can\'t got the problem,that reproduced on my environment. Result of running PL/SQL procedure on my PC on Eclipse SQL Explorer:
My procedure is declare here : create or replace PACKAGE MYPKG IS PROCEDURE MYPROCEDURE( sNomIN VARCHAR2, sValeurOUT VARCHAR2,
How can I use a store开发者_如何学JAVAd PACKAGE foo on the database using PL/SQL? Say the package contains a PROCEDURE bar. How can I call it?The procedure is called by ..
I am getting the below error. Don\'t know why this error is popping up. Please suggest: SQL> CREATE OR REPLACE TRIGGER test_trigger
I\'d like to create a Oracle package where I have a procedure that executes some dynamic SQL. This is no problem if I\'m doing it all dynamic with EXECUTE IMMEDIATE but it would be better if the stati
Assume a range of values inserted in a schema table and in the end of the month i want to apply for these records (i.e. 2500 rows = numeric values) the algorithm: sort the values descending (from the
加载中,请稍侯......