1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

CGI error (version=Header: glue.c 3.0.9): (in file)
Last GLUE procedure call was ExecPLSQL1()
/ARG 1/ declare l_titleno NUMBER(10) := :oid; l_ubarcode borrowers.barcode%TYPE := :barcode; l_title VARCHAR2(700); l_loan_per loanterms.loandays%TYPE; l_WorkString VARCHAR2(32000); begin SELECT title INTO l_title FROM titles WHERE titleno = l_titleno; SELECT MAX(NVL(loandays, 0)) INTO l_loan_per FROM copies c, loanterms lt, borrowers b WHERE c.titleno = l_titleno AND c.copycat = lt.copycat AND b.barcode = l_ubarcode AND b.borcat = lt.borcat; :firstcell := 'Availability calendar for: ' || l_title || '
' || '(The numbers indicate the number of copies that will be available from that day onwards until the next number is displayed)' || '
' || 'The loan period for this item is ' || TO_CHAR(l_loan_per) || ' days'; SetRes.AvailabilityCalendar(l_titleno, l_ubarcode, l_WorkString); :message := l_WorkString; end;
/ARG 2/oid
/ARG 3/barcode
/ARG 4/firstcell
/ARG 5/message
Failed to call PLSQL : "ORA-01403: No se ha encontrado ningún dato ORA-06512: en línea 9 "