pl/sql does not work with %rowtype

Posted by Manolo on Stack Overflow See other posts from Stack Overflow or by Manolo
Published on 2012-10-12T21:33:27Z Indexed on 2012/10/12 21:36 UTC
Read the original article Hit count: 218

Filed under:
|
|

I want to do a simple PL/SQL program on the Oracle 10g internet environment. The program is:

DECLARE
stud_rec students%ROWTYPE;
last_name VARCHAR2:='Clinton';

BEGIN
    SELECT * INTO stud_rec FROM students WHERE student_id=100;
END;

I have a table called students with data inside of it. The issue is that when I want to run this in the SQL command window I got this message:

  ORA-06550: line 3, column 11:
  PLS-00215: String length constraints must be in range (1 .. 32767)

I have checked the syntax and I cannot find the error. Any help? Thanks in advance

© Stack Overflow or respective owner

Related posts about sql

Related posts about plsql