Search results for query: *

I have compiled and run a pl/sql package on one schema's data then when I try to execute the same package from the same schema on another schema's data I get the error. 1st schema claudedemo 2nd schema xcs SQL> exec archive_database.select_data('claudedemo'); PL/SQL procedure successfully...

Here's a bit of a doozie I have written a an sql package to export data from tables owned by a schema entered at run time by the user. The script exports the data to a comma delimeted file this is fine but I have to take referential integrity into consideration and export the data in the order...

Right what i've got is a situation where I need to pass the table name to a procedure and open the cursor variable in the procedure with the variablr table name ptable when i try to compile this i get the error Errors for PACKAGE BODY CURSOR_WEAK: LINE/COL ERROR --------...

I am starting to use cursor variables but need a good boot in the general direction. The package spec compiles OK but when I compile the package body I get the following error: SQL> sho err Errors for PACKAGE BODY ARCHIVE_DATABASE: LINE/COL ERROR --------...

I am trying to start to use cursor variables I believe i have declared properly but get the following error on this code: I will be trying to pass the cursor with a table name CREATE OR REPLACE PACKAGE archive_database AS CURSOR get_tables(p_owner VARCHAR2) RETURN dba_tables%ROWTYPE; CURSOR...

I have just started writing packages in pl/sql and am having difficulty with cursors. Basically I want a cursor that will use a parameter passed into the procedure I have written the following code but when I try to compile it I get the error : LINE/COL ERROR --------...

I've only started trying to program PL/SQL packages and am having quite a lot of trouble, procedures on there own I can handle but when I try to compile the following code I get the subsequent error Any ideas why: CREATE OR REPLACE PACKAGE archive_database AS PROCEDURE select_data(v_owner IN...

I have just installed oracle server on my machine and am trying to use the utl_file package. I have created a database called cldtest. When I try to execute a simple procedure to just open a file and write to it I get the error note: SQL> exec select_data('claudedemo') BEGIN...