Hello I have one procedure like my problem is that P_SICIL or P_EXISTS can be too long so all length can be more then 4000 characters. when I call procedure it gives below error ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 14103, maximum: 4000) if I dont use to_char for clobs then I
Tag: procedure
PL/SQL procedure not compiling
I have a PL/SQL procedure that is not compiling. The errors are: Error(3,7): PLS-00103: Encountered the symbol “INTO” when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback
PL/SQL change value in 1 row in procedure
i do not know where the bug is. I must write the procedure where the 1 specific row will be chaned. Everytime i lunched it, wrote me: Errors: PROCEDURE RENAME_FLYTICKET Line/Col: 1/65 PLS-00103: …
PL/SQL procedure to output line the given date if not existing, latest date should be given
I have this table informationvalues with the contents: Now I create a procedure where I need to input a date parameter which should output line the correct attr with given price. If the date doesn’t exist the latest date should be selected. The solution table for to_date(’01-jan-19′) would look like this: This would be then output line in the procedure.
Syntaxerror in CREATE TABLE without any table creation but in procedure creation
I’m using Microsoft Access 2003, new to SQL tho. I have no idea why this wouldn’t work, google won’t help me either. The table “K_Lehrer” exists, and the code I have here is the only thing I wrote. My code is Error (translated): syntax error in create table statement error with code Answer Microsoft Access 2003 does not support stored
Creat procedure in mysql
I was learning sql from w3schools.Here is given simple mysql procedure but somehow I couldn’t to write down this procedure I’m new in sql please could you provide me with feedback. DELIMITER // …