National Student Clearinghouse(NSC) Interface PL/SQL Package
Thu, 2007-04-05 15:10 — cboersema
Hi all! We are currently working on a PL/SQL package to interface with the NSC using their server-side setup. This package redirects students to the NSC site and passes some data after communication exchange with their server. I was wondering if anyone has already devoloped this package and would be willing to share it, or could share pointers on issues you ran into. ~Thanks!~
Re: National Student Clearinghouse(NSC) Interface PL/SQL Package
We've been working on this as well.
Working from the NSC provided sample code, I have gotten limited functionality working, but only so far as to forward a (non https) page to the client. I've gotten a bit stuck on how to correctly access the wallet and/or to use it to fetch an https page; all I've gotten so far is an 'ORA-28759: failure to open file' error. Our oracle app server administrator is working on tracking this problem down for me.
I have run into the ip address issue mentioned at the top of the sample code. At the moment my fix for this is just a simple regexp_replace from '192\.168\.1\.\d{1,3}' to 'www.studentclearinghouse.org'. Not sure if this is the solution I will eventually go with, but for the moment at least it works alright.
Re: National Student Clearinghouse(NSC) Interface PL/SQL Package
Well, I finally got back to working on ssb page this week, and I had one of those "Of course!" moments and figured out what was wrong with my Oracle Wallet access: the DBA I was working with had creating the wallet on a different server then the one I was testing on.
We got that ironed out, development seems to be going pretty good now, and I think we just about have it.