The "Supervisor" and "Student_Name" are composite fields. Varchar2(62)ġ0 Sup_phone PERSON table supervisor phone number type Varchar2(20)ġ1 Sup_CUID PERSON.LOGIN_ID/Varchar2 (20)ġ2 Person_Status PERSON.PERSON_STATUS/Varchar2 (20) The record set output Record (t_EmployeeRef) looks like:Ģ RC_Code PERSON.LOCAL_PERS_ID/Varchar2(20)ĥ Job_Title PERSON.JOB_TITLE/Varchar2 (40)ħ State PERSON.ADDRESS_STATE/Varchar2 (10)Ĩ Mgt_Level PERSON.MGT_LEVEL/Varchar2 (10)ĩ Supervisor PERSON table supervisor name from SSN lookup. Without getting too much in depth the store procedure is: I understand that the only stored procedure that can be written in oracle that will work in Crystal Reports is a ref cursor. This is going to be difficult because I didn't write the stored procedure and I don't have access to it because it's written by an outside source.
0 Comments
Leave a Reply. |