Hi I run this query to read the count of the Records with an output parameter using OracleCommand: var query = "declare MyCount number; begin SELECT COUNT(*) INTO :MyCount FROM T_ISSUE; end;"; this one works fine. But if I split the query into two lines like this: var query = @"declare MyCount number; begin SELECT CO...
Hi, Below is my Oracle Procedure. When i call this procedure using java, it throws error like this. CREATE OR REPLACE PROCEDURE sp_Get_Menu_Parents ( v_inMenuID IN VARCHAR2 DEFAULT NULL, cv_1 IN OUT SYS_REFCURSOR ) AS BEGIN OPEN cv_1 FOR SELECT MenuItemId, MenuItemName, MenuItemDisplayName, ...
I am getting the following error when trying to execute a stored procedure in Oracle that contains two input parameters: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'P_GET_NEXT_AVAILABLE_RUN' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Both input parameters require values...
Hi, Im trying to execute a refresh on a materialized view, but I cant get the script to compile. CREATE OR REPLACE PROCEDURE REFRESH_MV AS BEGIN exec DBMS_MVIEW.REFRESH('my_mat_view_mv','C'); END REFRESH_MV; I get the message: ORA-06550: line 3, column 9: PLS-00103: Encountered the symbol "DBMS_MVIEW" when expecting one o...
Can someone please explain to me why I keep getting this PLS-00905 error for the below simple procedure? Thank you. create or replace procedure copy_table( table_name IN varchar2, database_link IN varchar2, suffix IN varchar2, table_owner IN varchar2) IS begin execute immediate 'create table ' || table_name || '_'...
My Scenario: Schema name: schema1 Package name: pkg_system procedure name: proc1 Now I am trying to create a synonyms for my proc1 as below CREATE PUBLIC SYNONYM call_proc FOR schema1.pkg_system.proc1; ...but it gave me syntax error. ORA-00933: SQL command not properly ended I changed the code as below: CREATE PUBLIC SYNONYM c...