|
Home > Archive > Oracle certifications > June 2002 > REF question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| odonata 2002-06-23, 7:22 pm |
| Hello,
I get the concept of REF columns in regard to when you run the Data Block Wizard and selecting a ref column, but how do these ref columns get created in the first place??
Thank you. | |
| mhusain 2002-06-26, 7:40 am |
| REF cursor r created while u create a stored procedure. REF cursor r pointers to the SELECT statement in a stored procedure.
When such a stored procedure is made a data source in the Data Block Wizard those columns r visible.
You have to create the stored procedure with a REF cursor prior to using it as a data source in the Data Block Wizard.
Hope this helps
Mohammad
mhusain714@yahoo.com | |
| odonata 2002-06-26, 8:01 am |
| Thanks for the reply, but how does an ACTUAL REF column get created in the first place?
As in you can have a table, and one column could be a REF column, so even when setting up data blocks in a form module, you could set it up based on a table/view, but that table may contain a REF column (so, then you get 2 instances, the REF item, and the actual data), but I am wondering how the ref column was created in the first place in a table?
Thanks again! |
|
|
|
|