Using Stored Procedure

[byteias]

CR XI Oracle 9i.
I created a stored procedure for my report, and it runs fine until I decided to add more fields to my Proc. When I run CR as new (logging to Oracle) I don't see my new fields. I logged off from CR and logged on again and the new fields aren't there....
The Proc show as valid.
Any idea why I cannot see them?
Thanks,
Ivan.

 

[byteias]

If I create a new report using the same stored Proc, it will show up everything (my new added fields).
I don't understand why is doing it and I don't want to think that is the only way of doing it.
Thanks,
Ivan

 

[Turkbear]

Hi,
Did you issue a 'Verify Database' command ( from the database menu) after the changes?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[byteias]

it works now when I issue a 'Verify Database'
Thanks for your help.
Ivan.

 

[Turkbear]

Hi,'
No problem..Been there, done that..






To Paraphrase:"The Help you get is proportional to the Help you give.."