 | |
Best idiom for looping over input?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Best idiom for looping over input? -
08-28-2008
, 01:58 PM
#2
| |||
| |||
|
|
After *moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many TIA! old code: * * call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp) new code (broken): * * call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp) * * ORA-01747: invalid user.table.column,table.column, * * * * * * * *or column specification new code (works): * * begin p4asset.add(:typename,:repos,:depotFile,:rev); end -- Mark Harrison Pixar Animation Studios |
call p4asset.add(:typename,:repos,:depotFile,:rev)
/
should work. I have no problems using call to execute procedures
inside of a package.
David Fitzjarrell
#3
| |||
| |||
|
|
After *moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many TIA! old code: * * call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp) new code (broken): * * call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp) * * ORA-01747: invalid user.table.column,table.column, * * * * * * * *or column specification new code (works): * * begin p4asset.add(:typename,:repos,:depotFile,:rev); end -- Mark Harrison Pixar Animation Studios |
call p4asset.add(:typename,:repos,:depotFile,:rev)
/
should work. I have no problems using call to execute procedures
inside of a package.
David Fitzjarrell
#4
| |||
| |||
|
|
After *moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many TIA! old code: * * call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp) new code (broken): * * call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp) * * ORA-01747: invalid user.table.column,table.column, * * * * * * * *or column specification new code (works): * * begin p4asset.add(:typename,:repos,:depotFile,:rev); end -- Mark Harrison Pixar Animation Studios |
call p4asset.add(:typename,:repos,:depotFile,:rev)
/
should work. I have no problems using call to execute procedures
inside of a package.
David Fitzjarrell
#5
| |||
| |||
|
|
After *moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many TIA! old code: * * call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp) new code (broken): * * call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp) * * ORA-01747: invalid user.table.column,table.column, * * * * * * * *or column specification new code (works): * * begin p4asset.add(:typename,:repos,:depotFile,:rev); end -- Mark Harrison Pixar Animation Studios |
call p4asset.add(:typename,:repos,:depotFile,:rev)
/
should work. I have no problems using call to execute procedures
inside of a package.
David Fitzjarrell
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.