Print Thread
Array DML: declaration
#49954 01/05/15 05:29 PM
Joined: Jul 2014
Posts: 19
I
icegood Offline OP
Member
OP Offline
Member
I
Joined: Jul 2014
Posts: 19
It's clear from documentation on how to declate 'PL/SQL Table' at runtime
(DeclareVariable + DimPLSQLTable.) but i don't see any guide on how to declare simple array variable at runtime for Array DML...
I'm using DOA 4.1

Last edited by icegood; 01/05/15 05:32 PM.
Re: Array DML: declaration
icegood #49956 01/05/15 05:59 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
You mean at design-time? The variable editor form has a "PL/SQL Table" checkbox and a table size and string size property.


Marco Kalter
Allround Automations
Re: Array DML: declaration
Marco Kalter #49965 01/06/15 08:14 AM
Joined: Jul 2014
Posts: 19
I
icegood Offline OP
Member
OP Offline
Member
I
Joined: Jul 2014
Posts: 19
no, i mean 'PL/SQL Table' vs 'Array DML' variable

Re: Array DML: declaration
icegood #49966 01/06/15 10:12 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
PL/SQL Tables and Array DML are unrelated.

Array DML cannot be declared at design-time. It requires that you pass a variant array for each variable of the query. The variables are declared as usual.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.026s Queries: 14 (0.009s) Memory: 2.5070 MB (Peak: 3.0425 MB) Data Comp: Off Server Time: 2024-05-19 00:23:09 UTC
Valid HTML 5 and Valid CSS