BDN - Banner Developer Network

I can create the button etc. However, I have no idea what code to use to launch Windows Explorer, and then to 'extract' the file name & path chosen by the user.

Have done some research on it, but just find myself getting more confused. Can anyone point me in the right direction here please - any assistance greatly appreciated!

Thanks,

Emer

Email via plsql - has anyone created a plsql web package form that allows users to attach files and send email via UTL_SMTP. I can setup a form that allows faculty to send messages to their students without needing to have Outlook installed to use those email links on the class roster SSB pages. I am trying to see if anyone knows how I could get a web pl/sql form allow a small attachment so they can send a email with attachment via a PLSQL application.

Thanks,
Ed

Has anyone been successful in calling an outside web service from Banner in a batch PL/SQL process (online would be even better) using a SOAP call and XML?

I am in the process of writting a query that would pull the list of all students enrolled for classes in a given semester, then segregate the results (by class) into flat files, dynamically saving the resulting flat files with the corresponding classes the students are enrolled in.
I have written the query to pull the entire student list as such;

SET NEWPAGE 0;
--SET SPACE 0;
SET LINESIZE 120;
SET PAGESIZE 10;
--SET ECHO OFF;
--SET FEEDBACK OFF;
--SET VERIFY OFF;
SET HEADING OFF;
SET trimspool OFF;

spool student_course;
break on course skip 2

I'm attempting to use the API Toolkit for Banner 7 APIs to create an API for a local table. I was able to create the dml package for the table but when I try to run gurmkpk_api.sql it does not generate a complete spec and body. The last line in the output file is:

Exception in p_gen_api:-6502:ORA-06502: PL/SQL: numeric or value error

If I comment out the exception line in entity_api_generator.p_gen_api and run gurmkpk_api.sql again the errors are:

DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "ROBERSOT.ENTITY_API_GENERATOR", line 587