using "pl/sql function body" for default value of an item
97164Jan 7 2005 — edited Mar 16 2006I have created a function xprim giving a maxvalue+10(p.e. select max(deptno)+10 into newv from dept)
for using it as default value for an item:
the items default value is TYPE= PL/SQL expression and value= xprim;
this works fine !
But how could I do this if I want to use TYPE= PL/SQL function body ???
I tested someting but no success; My problem is how to define the desination. :P1_X := 10 (TYPE= function body)
no error, but did not work bu
( I do not want to use a trigger or sequence !)
Thanks