Posted By: PV (Blaaaa...) on 'CZdatabases' Title: FW> Oracle a balicky Date: Fri Sep 3 16:39:30 1999 Nazdar lidi, mam problem na oraclu Oracle7 Server Release 7.3.4.3.0, v PL/SQL Release 2.3.4.3.0 Mam balicek, ktery vypada nasledovne: CREATE PACKAGE balicek AS PROCEDURE mojeproc; END balicek; / CREATE PACKAGE BODY balicek AS PROCEDURE vlozeni (s IN INTEGER) IS BEGIN INSERT INTO CislaTemp VALUES (s); END; PROCEDURE mojeproc IS CURSOR c1 IS SELECT * FROM CISLA; Cislo INTEGER; BEGIN OPEN c1; LOOP FETCH c1 INTO Cislo; EXIT WHEN c1%NOTFOUND; VLOZENI (Cislo); END LOOP; END mojeproc; END; / Kdyz ho natahnu, zda se byti vse v poradku: SQL> @bal2 Package created. Package body created. Ale kdyz jej chci spustit, objevi se nasledujici: SQL> execute mojeproc begin mojeproc; end; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'MOJEPROC' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Co s tim? A jeste jeden dotaz: k cemu tam slouzi ta lomitka? Diky za odpovedi .-----------------------------------------------------------------------------. | ,,Problem je vzdy mezi zidli a klavesnici`` _ PV | | mail: bla@atrey.karlin.mff.cuni.cz _ "-()---------------) alias | | http: atrey.karlin.mff.cuni.cz/~bla (_) '-"~~~~~~~~~~~~~-' Bla | `-----------------------------------------------------------------------------'