Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: INSERT in PL/SQL
Thank you for reply, Thomas
Thomas Kyte wrote in message <35507366.4852627_at_192.86.155.100>...
>it. You are trying to call Y from the SQL statement -- Consider all
>INSERT/UPDATE/DELETE/SELECT etc type statements to be procedure calls
outside of
>your package. It is as if INSERT was a procedure you were calling. when
you
>called it, Y went out of scope -- it isn't visible to INSERT. That also
>explains why when you moved it into the SPEC, you still needed to call
>test.y(1), not just y(1). When you called INSERT, you were no longer in
the
>test package but some other scope and had to qualify the reference to y
with
>test.
But why are internal package variables visible in the scope of SQL statements? According to the concept described, only public package variables (qualified by the package name) would be allowed for use, but it isn't so. Is it a sort of exception?
SY
Anton
Received on Thu May 07 1998 - 03:03:35 CDT