Link to SSB Package - Need Help
Hello
I need a little bit of assistance from you guys. I am working with someone to try to create a link in a channel in Luminis. This link needs to run a package that was installed in oracle/banist1 and granted to www_user. This package is basically a simple Oracle package that gets the student's SPRIDEN_ID and then passes the student to another page with the SPRIDEN_ID in a form. This part isn't the important part.
What I need to know how to do is create a link in Luminis that will execute this package that I have installed in Oracle/Banner (let's call it . I am thinking I first need to create a web menu/procedure in SSB and then somehow link to it in Luminis, but I am pretty confused about how I would do that.
Any help at all would be very appreciated.
Thanks!
ssb package link
Links to ssb are usually in this form:
http://portal.domain.edu/cp/render.UserLayoutRootNode.uP?uP_tparam=utf&utf=http%3A%2F%2Fportal.domain.edu%2Fcp%2Fip%2Flogin%3Fsys%3Dsctssb%26url%3Dhttps%3A%2F%2Fself-service.domain.edu%2Fprod%2Ftwbkwbis.P_GenMenu%253Fname%253Dbmenu.P_RegMnu
Depending on where you put the link, you may need encoding, or may not. The above link would open the page within the portal frame.
Otherwise, you could use a simpler form like:
http://portal.domain.edu/cp/ip/login?sys=sctssb&url=http://self-service.domain.edu/somepath/somepage
it's possible
I found a way to do this. It may not be the best way to do it but it works for us.
On the banner/oracle side you'll need to grab the sso cookie using twgkwbis.p_fetchsecurecookie and parse the cookie so you can grab the pidm from it. Once you have the pidm you'll be able to do whatever you want with it.
Be sure to add your schema.package.procedure to webtailor so the page can render.
Example Procedure below:
Procedure p_myproc
is
pidm SPRIDEN.SPRIDEN_PIDM%TYPE := NULL;
cookie_value VARCHAR2(2000) := '';
BEGIN
twgkwbis.p_fetchsecurecookie(cookie_value);
IF cookie_value IS NOT NULL THEN
global_pidm := TO_NUMBER(SUBSTR(cookie_value, twgkglib.f_pinlength + 1));
ELSE
global_pidm := NULL;
END IF;
htp.p('User PIDM is:'||pidm);
END;
On the luminis side:
Create a configman entry to the package something like:
configman -s es.sct.api.myschema.mypacakge.p_myproc "\${es.sct.host}:\${es.sct.port}\${es.sct.banner.vpath}/myschema.mypacakge.p_myproc"
A restart of luminis is required for the above change to take effect.
Now you can add the link inside luminis
http://luminis.myuniversity.edu/cp/ip/login?sys=sct&api=myschema.mypacakge.p_myproc
which will take you directly to the package.
If you get an external system error and your luminis session is killed you haven't done the configman right and or done a restart.
if you get a 404 page not found then you haven't added the package to web tailor or there is an error in the package.
hope this helps.