I am using Dan McGhan’s article http://www.danielmcghan.us/2016/03/tutorial-creating-component-similar-to.html to pull back values from a modal dialog. It is working nicely.
But now I want to do something with that data. A simple select. However when I add the pl/sql to the dialog closed dynamic action I get the ORA-0143 error
The Java script dynamic action
$s('P8001_CUSTOMER_DISPLAY', this.data.P8002_DISPLAY);
$s('P8001_CUSTOMER_ID', this.data.P8002_ID);
If I stop at this point all is well and the value of P8001_CUSTOMER_ID is populated.
Followed by the PL/SQL dynamic action
SELECT
product\_nm,
product\_type
into
:P8001\_product\_nm,
:P8001\_product\_type
FROM
product\_v
where
customer\_id = :P8001\_CUSTOMER\_ID;
This results in ORA-01403