#Quoted string not properly terminated code

V_sql := v_sql ''' || '.' '' || v_dba_tables.table_name || ''' TO pengcf ' ĭBMS_OUTPUT.put_line(v_dba_tables.table_name || ' granted successfully.') ĭBMS_OUTPUT.put_line('Totally ' || v_flag || ' tables granted to pengcf.') ĭBMS_OUTPUT.put_line('Acutally there are ' || v_cnt || ' tables on test. SELECT count(*) INTO v_cnt FROM dba_tables WHERE owner = 'TEST'

#Quoted string not properly terminated code

I consider it for a while and determine to write a piece of PL/SQL code for accomplishing this business requirement. At the same time I found there're approximately 200 number of tables on specific user, so it's impossible/inconvenient to grant per table to new user. SP2-0042: unknown command 'THEN' - rest of line ignored. Oracle Application Express (APEX) - Version 19.1 and later: When Importing Application, ORA-01756: quoted string not properly terminated. Oracle Database - Enterprise Edition - Version 11.2.0.1 and later: ORA-01756 - 'quoted string not properly terminated' When Running Valid XQuery Statement. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. SP2-0734: unknown command beginning 'IF SQLCODE.' - rest of line ignored. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. SP2-0734: unknown command beginning 'exception. This usually happens when you copy/paste SQLs from web sites, PDFs or Word documents. Action Insert the closing quote and retry the statement. ERROR: ORA-01756: quoted string not properly terminated SP2-0734: unknown command beginning 'return SQL.' - rest of line ignored. It seems your quot characters are not correct, some of them are ' which is correct, but others are Unicode ‘ (0x2018) characters which is incorrect. You tried to execute a statement that contained a string that was not surrounded by two single quotes. Oracle Database Database Error Messages Updated JReleases 23c, 21c, 19c ORA-01756 quoted string not properly terminated Cause A quoted string must be terminated with a single quote mark ('). My Oracle Developer manager let me to create a user and, whom has just been granted 'select' privilege from another user's all of tables to. ORA-01756: quoted string not properly terminated.