Very simple proc, but can't execute it!!! Getting the dreaded ORA-06512 error:
PL/SQL: numeric or value error: character string buffer too small
PROC:
CREATE OR REPLACE PROCEDURE jjblogp.pgetblogdescriptio
n(
inBLOG_ID IN NUMBER,
outBLOG_DESCN_TXT out varchar2
)
AS
BEGIN
SELECT BLOG_DESCN_TXT into outBLOG_DESCN_TXT
FROM jjblog.blog
WHERE BLOG_ID = inBLOG_ID;
END;
/
What am I doing wrong???
Start Free Trial
