During a recent project assignment, I had to generate Oracle 11g "pipelined" functions using Sybase
Powerdesigner 16.1.
The stock Powerdesigner does not provide a "pipelined" keyword for Oracle.
But, luckily, Powerdesigner has an excellent metadata system which can be used to add the necessary keyword on demand.
The stock Powerdesigner does not provide a "pipelined" keyword for Oracle.
But, luckily, Powerdesigner has an excellent metadata system which can be used to add the necessary keyword on demand.
- from the main menu, choose Database/Edit Current DBMS...
- in the General tab, right-click Profile and choose Add Metaclasses...
- click on the DatabasePackageProcedure selection box, then OK
- right-click DatabasePackageProcedure and choose New->Extended Attribute
- name the new attribute IsPipelined, use false as the default value and click Accept
- in the tree-selection, go to Script/Objects/DB Package Procedure/Add
- in the Value text-field, replace this existing code:
%DBPKPROCTYPE% %DBPKPROC%[ (%DBPKPROCPARAM%)][ return %DBPKPROCRETURN%][ [.O:[as][is]] %DBPKPROCCODE%]
with this one:
%DBPKPROCTYPE% %DBPKPROC%[ (%DBPKPROCPARAM%)][ return %DBPKPROCRETURN%][%IsPipelined%? pipelined][ [.O:[as][is]] %DBPKPROCCODE%]
and choose OK. The DBMS properties window will close and Powerdesigner will ask you to save the changes you just made - click Yes. - open the appropriate database function and right-click to open it's properties
- activate the new IsPipelined attribute in the Extended Attributes tab for "pipelined" functions