SRW package

Fasih Raheel

hi, can anyone please provide me SRW package spec and body script..

Ora_Learner890

those are built-in of Report Builder, you can just find " what are these functions/procedures/exceptions  " and " how to use... (syntax) "

hope these will help

http://www.oracleerpappsguide.com/2011/03/srw-package-in-oracle-report.html

myscripts: Oracle Reports - SRW PACKAGE most useful procedures

Gopal's Oracle ERP School: SRW Package in Oracle Report

a pdf book (official) for complete reference:

https://docs.oracle.com/cd/A97335_02/busint.102/a73174.pdf

EDIT: please use a human readable name instead of numbers

Fasih Raheel

hi ora_learner,

     many thanks for your reply, yeah i know its a builtin package in report builder, but i need its source so i can deploy this package on server and execute procedure which distribute report on email. in my procedure this package called.
once this package i have downloaded from internet a long ago my bad i haven't save this, through google search but now m unable to get.
i have changed my name , dont know why it is not appearing yet

Ora_Learner890

i don't know about any SRW package source, may be someone created it and published on net.

anyway, try to find if you have previously, hope for the best

please check again with your profile where this number mentioned, change it.

Matej D.

You did't mention report server version.

Sql for installing srw package are usually in $ORACLE_HOME/reports/admin/sql (reports 12c).

Regards

Fasih Raheel

hi Matthew,

     i didn't find any reports folder in $ORACLE_HOME, (12C database).

also i find spec and body of SRW in 11g reports builder folder , what i found is .plb extension file which is unable to unwrap and shows some error while unwrapping "The code does not seem to be valid wrapped PL/SQL code. The binary (Base64 encoded) part is invalid or incomplete."

Please advise.

Matej D.

I mean ORACLE_HOME in forms/reports installation.

Regards