Dear All,

I have a problem when I want to create a store procedure. I am sorry if it very simple thing, because I am new in oracle.

Here the script that I have make:

CREATE OR REPLACE PROCEDURE SYSTEM.Book_Test (@id NUMBER) AS
DECLARE
judul1 VARCHAR2;
BEGIN
SELECT judul INTO judul1 FROM BOOKS WHERE id_book=id;
END Book_Test;
/
And it error;

I am very thanx for any reply. I hope anyone can help me.

Thanx