[NewToPCGuy]

I need to query a table in a database that I need to write to to determine what records I need to pull from the database I need to read from.
Example(This dosnt work):

DECLARE

DateVar Date;

BEGIN

DateVar := Select MAX(Invoice_Date) from write_To_Table;

COPY FROM read_database TO write_database INSERT-
destination_table (column_name, column_name...) -
USING select * from read_From_Table where invoice_Date > DateVar;

END;

Any other suggestions

[RedAxl]

Hi,

What you need to do is:
- Connect to write_database.
Query the DateVar for your WHERE condition.

- Connect to read_database.
Query all the records what that you want to insert to write_database.
Then store the records to "ARRAY"

- Connect to write_database.
Insert your "ARRAY" to destination_table

I hope this helps.

Red

[NewToPCGuy]

Thanks for your reply RedAxl

The problem seems to be that
COPY FROM ...

doesnt seem to work in a plsql procedure. Is there a way to create and use a variable outside of a procedure?

[RedAxl]

Just pass the variable/s as a parameter to a procedure.