Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- isFound NUMBER := 1;
- BEGIN
- SELECT COUNT(*) INTO isFound FROM CATEGORIES WHERE id = 24;
- IF isFound < 1 THEN
- --insert
- INSERT INTO CATEGORIES(ID, ORDER_NR, NAME_SE, NAME_FI, SHOW_IN_MENU) VALUES (24, 130, 'diipa', 'daapa', 1);
- END IF;
- END;
- [2017-12-05 13:56:08] [65000][6550] ORA-06550: rivi 1, sarake 8:
- [2017-12-05 13:56:08] PLS-00103: Symboli "" löydetty odotettaessa jotakin seuraavista:
- [2017-12-05 13:56:08] BEGIN
- [2017-12-05 13:56:08] FUNCTION PACKAGE PRAGMA PROCEDURE SUBTYPE TYPE USE <tunniste>
- [2017-12-05 13:56:08] <erotinta käyttävä tunniste lainausmerkeissä> form CURRENT
- [2017-12-05 13:56:08] CURSOR
- [2017-12-05 13:56:08] Symboli "" ohitettiin.
- [2017-12-05 13:56:08] ORA-06550: rivi 2, sarake 23:
- [2017-12-05 13:56:08] PLS-00103: Symboli "" löydetty odotettaessa jotakin seuraavista:
- [2017-12-05 13:56:08] BEGIN
- [2017-12-05 13:56:08] FUNCTION PACKAGE PRAGMA PROCEDURE SUBTYPE TYPE USE <tunniste>
- [2017-12-05 13:56:08] <erotinta käyttävä tunniste lainausmerkeissä> form CURRENT
- [2017-12-05 13:56:08] CURSOR
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement