Saii
Joined: Apr 5 '07
Location:
-
can you please explain your problem again, it is not clear whether you want to generate a report or a stored procedure writing to file or display the records using forms? -
Visit postgresql.org and search for ora2pg. you may find some informationLeave a comment:
-
Re-check your trigger code for following
1. There are no :old values when inserting to a table.
2. This is row level trigger, you need to store the values of the row to use it later.Leave a comment:
-
In 11g, Oracle has introduced something called SecureFiles architecture to deal with this. Maybe you can have a look at that.Leave a comment:
-
regexp_substr(' com.integrosys. sml.app.facilit y.vo.OBFacility[5647].Pricing Result','[[:digit:]]{4}'
hope it helpsLeave a comment:
-
Do want to store the whole file or just the name and pointers to the file location in database?Leave a comment:
-
You can create a user defined aggregate function to concat the values. Search for ODCIAggregateLeave a comment:
-
Pass Perl array to Oracle stored procedure
How can we pass a perl array to stored procedure in Oracle.
The parameter I am using in Oracle is type of table of varchar(500). I am using the system command in perl to execute the procedure
Sample:
When I use the above...Code:system("sqlplus -S $user_det_orcl <<EOF \n "."whenever sqlerror exit failure; \n"."exec p_test('\@array\');\n"."exit;\n"."EOF\n" );Last edited by eWish; Apr 28 '09, 10:11 PM. Reason: Please use code tags to make the code more readable -
What about the documented method of using 3 triggers to avoid mutating errors.
Before insert for each row to set package variable(array) .
after insert for each row to get the unique id of rows inserted and store sin package array
after insert statement level- to do whatever procesing u want for the rows in packaged array
This doesnt work???Leave a comment:
-
I vote for autonomous transaction but i think committing through triggers should be limited to auditing purposes only.Leave a comment:
-
You want to load the data file name into the table so I am guessing that for all the rows in that file, the name will be same. just from top of my head,i guess you can load this column as blank and issue an update statement just after loading the data in your script(assuming you are doing this in script).
If this is not helping can you provide a sample of the control file and explain your current approach of implementing this process.Leave a comment:
-
Can you please elaborate some more -is this column not available in data file, at what position you want to insert,where to insert this row as you said "insert a value (file name) before each row into the table."Leave a comment:
-
I dont we can set linesize 0 its valid range starts from 1Leave a comment:
-
declare
type array_var is varray(10) of number(10,2);
tem_array array_var :=array_var();
begin
for i IN 1..10 loop
tem_array.exten d;
tem_array(i) := i+1;
end loop;
end;Leave a comment:
-
In 10g, try experimenting with alter table options like rename,drop unused. I haven't tried but i think it should work.Leave a comment:
-
Which Oracle version are you using? In 10g you can use regular expressionsLeave a comment:
-
try using Oracle 10g Heterogeneous ServicesLeave a comment:
-
Saii replied to I want a query to find all entries on table1 without a corresponding entry on table2in Oracledid you try using "not exists"?Leave a comment:
-
Postgres to Oracle
what is the equivalent of CREATE CAST and CREATE AGGREGATE in Oracle, if any? -
I dont think you can have global variables like forms in oracle reports. But maybe you can use placeholder columns in data model.Leave a comment:
No activity results to display
Leave a comment: