| Oracle SQL parallel query within PERL [message #449868] |
Thu, 01 April 2010 14:20  |
jbrizu2
Messages: 2
Registered: April 2010
|
Junior Member |
|
|
Hello - I am trying to run an oracle parallel query within a perl script but it will not work. I am getting the following error: ORA-24373: invalid length specified for statement (DBD ERROR: OCIStmtPrepare)
I would appreciate any sugguestions on what to try in order to get this to work.
sub cre_mob_arch_tmp {
print " (*) Creating Base of Mobility Trouble_Ticket_Archive Tickets ...\n";
$sql_statement = `
Create table mob_arch_tmp as select /*+ PARALLEL(a  */ * from trouble_ticket_archive@mobility a where to_char((TO_DATE('1970-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')+NUMTODSINTERVAL("CLOSED_TIME"-14400,'second')), 'DD-MON-YY') = to_char(sysdate-1, 'DD-MON-YY')
/
`;
unless ($rows = $dbh->do("$sql_statement")) {
&programError("Could not create table MOB_ARCH_TMP", "$sql_statement", "$DBI::errstr", "dba", "jbriz");
$dbh->rollback;
&logoffOracle($dbh);
exit;
}
} # sub cre_mob_arch_tmp
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
