Hi,
I have a table on a different database than my main database and via a database link and synonym I can access it from my main database in sqlplus, by e.g.
SELECT count(*) FROM table_on_secondary_db;
As soon as I try to access it within a Begin - End block, like:
DECLARE
counter...
Hi,
the advantage of NAME_IN('Block.Item') is that you can use it in PLSQL-Libraries the notation of :Block.Item would cause an compilation error. Another advantage is (together with the COPY function) you can use dynamic variables, e.g. you have in your form items called name_1, name_2,... you...
Information: On the page http://sqlzoo.net, there under Functions you can find how functions are used in MySQL, Oracle, SQL Server, Access and Postgres.
I don't know if this will work foryour data base, it did work on my Oracle data base.
Insted of a cursor and loop I just used an update statement:
UPDATE tablename t1
SET t1.ItemID = DECODE( t1.ItemID,
null, ( SELECT MAX(t2.ItemID)
FROM tablename...
I the error was raised during compilation. I don't know about the error number, but usually when I get the error message "Internal Error" I close the form, open it again, and compile it again, then it usually works.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.