why make_ref cannot be referenced from a pl/sql procedure [message #36534] |
Mon, 03 December 2001 06:17 |
dj
Messages: 8 Registered: December 2001
|
Junior Member |
|
|
I have an object view say fooview with object
identifier fooid.
In a package, I try to use make_ref in a procedure
like this:
select make_ref(fooview, fooid) from dual;
And I got this error:
PLS-00201: identifier 'MAKE_REF' must be declared
Can somebody tell me why I could not reference make_ref
and how can I solve it?
Thanks.
----------------------------------------------------------------------
|
|
|
Re: why make_ref cannot be referenced from a pl/sql procedure [message #36573 is a reply to message #36534] |
Wed, 05 December 2001 04:11 |
Deepu
Messages: 3 Registered: December 2001
|
Junior Member |
|
|
as far as I know the syntax is MAKE_REF(object,foreign_key) building on this syntax, below is a code which I hope will sort ur doubts
CREATE VIEW emp_view OF emp_t WITH OBJECT IDENTIFIER(eno)
AS SELECT e.empno, e.empname, e.salary,
MAKE_REF(dept_view, e.deptno)
FROM emp e;
The above statement creates a view emp_view with a reference to the department in which the employee works. so u ses e.deptno is actually a foreign key to the dept table. dept_view is just a simple view on the dept table.
hope this info was useful, any concerns on this get back to me, I will be glad to help.
regards
Deepu
----------------------------------------------------------------------
|
|
|