 |
|
|
| Related Topics: | Passsing parameters between procedures - Hi, I currently have a package and contained within it I have 2 procedures. The first procedure has a parameter (SEQ_ID) passed into it from a sequence (sequence_name.NEXTVAL) which works fine. What I need to do is to pass that parameter into the..
Pro*C Dynamic SQL calling functions/procedures - Hi all, In the Pro*C code at the bottom, I was trying to execute a function that returns a cursor. However, as I would only know the exact name of the function during runtime, I tried to create a dynamic statement calling the function (by inserting the....
realistic cardinality for PL/SQL procedures in SELECT stat.. - Oracle 9.2.0.7 on SuSE Linux (AMD 64) db_block_size=<<16 kb>> Maybe you can help me on this problem with the CBO. If I use a simple query like select * from TABLE_A a, TABLE_B b where a.NAME = b.NAME and a.KEY_IN_A = 'X'; the...
Replacing a subselect with Collections - Hi all oracle users, I have a cursor which fetches a few thousand records. Inside it I have a subselect which is used for decoding one field. CURSOR snap_crs IS SELECT decode (snap.id, 1, (select code_ptr from anag_ptr where desc_ptr =..
how to refresh a sequence - How could I refresh a sequence in Oracle using an SQL statement? I've got the problem, that the current number of a sequence is less the highest index in a table, where I want to use the sequence. Regards, Robert |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
