Home » SQL & PL/SQL » SQL & PL/SQL » why make_ref cannot be referenced from a pl/sql procedure
why make_ref cannot be referenced from a pl/sql procedure [message #36534] Mon, 03 December 2001 06:17 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: how to get ref of an object
Next Topic: Test for Numeric Function
Goto Forum:
  


Current Time: Mon Mar 30 02:17:24 CDT 2020