Executing Server side procedure and publishing result on HTML
source code will be avalibale soon web.show_document('http://moiserver:7778/appweb/PKG_Download_BLOB.Download_Blob?P_tbl=CE_NOTICE&p_tranid=':CE_NOTICE.NOTICE_RECID,'_blank');
END ;
another example
CREATE OR REPLACE procedure TEST.queryemp is
cursor emp_cur is
select ename,sal
from emp;
begin
htp.prn(' ');
htp.prn(' ');
htp.prn(' Employee Data ');
htp.prn(' ');
htp.prn(' ');
for i in emp_cur loop
htp.prn(' ');
htp.prn(' '||i.ename||' ');
htp.prn(' ');
end loop;
htp.prn(' ');
htp.prn(' ');
end;
/
--- dads conf
SetHandler pls_handler
Order allow,deny
Allow from All
AllowOverride None
PlsqlDatabaseUsername test
PlsqlDatabasePassword test
PlsqlDatabaseConnectString pmstst
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
PlsqlDocumentTablename smm_doc_table
...