Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with variable in procedure

646894Jan 21 2010 — edited Jan 21 2010
Hello,

I have a string in a variable.

ignore_column_name := 'LAST_NAME';

I have a cursor in a procedure

CURSOR C1 is
SELECT column_name
FROM user_tab_columns
WHERE table_name = 'PATIENT'
AND column_name NOT IN (ignore_column_name);

I am using the above output to generate a column list and hence i should not be seeing 'LAST_NAME' in the output.

But this is not the case. For some strange reason the variable value does not get substituted into the cursor.

Could someone please help me get the desired result.

Thanks

Comments

Ices_Eyes
Up...!
Ices_Eyes
Noone is experiencing the same issue?
-K-
My suggestion is to open a SR at Metalink/MOS (if you have a database support contract), else hope someone from the team is interested in logging/debugging this through the forum.

Regards,
K.
Ices_Eyes
-K- wrote:
My suggestion is to open a SR at Metalink/MOS (if you have a database support contract), else hope someone from the team is interested in logging/debugging this through the forum.

Regards,
K.
Unfortunately I have no a support contract, so...Hoping someone of the developer read this...Maybe it will be fixed in the next release :)

PS: if some developer read this, please let me know, so I stop to try to mantaint this thread alive :P
Ices_Eyes
Any news about this bug? :)
hlaebe
Hi,
did you try GeoRaptor [GeoRaptor |http://sourceforge.net/projects/georaptor/] ? We have tools for indexing, maintaining metadata (which might be the reason for this non-support in SQL Developer, since metadata is required for indexing).

Give it a try, it is free!

Regards,
Holger

Edited by: hlaebe on 03.02.2010 08:56
Ices_Eyes
Thanks, that work! And is pretty useful too... :)
Ices_Eyes
By the way, this bug is still present in version 2.1.1... :-S
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 18 2010
Added on Jan 21 2010
4 comments
467 views