![]() 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' If you don’t have this taken care of, your CLI may attempt to run the first block of code until it. And if you have multi-line strings with blank lines, consider SET SQLBL ON. You tried to execute a statement that contained a string that was not surrounded by two single quotes. For example if you have ’s in your data, consider SET SCAN DEFINE OFF. ORA-01756: quoted string not properly terminated. You can pass the value using a bind parameter when you want to use it as a literal value and use string concatenation when you want to use it to dynamically generate a column name. I consider it for a while and determine to write a piece of PL/SQL code for accomplishing this business requirement. If you’re using INSERT scripts, make sure you have the environment set based on your needs. Action: Rewrite the statement so that the string is surrounded by two single quotes. ![]() One of the quotes was entered without the second accompanying quote. I got the following exception from the devart driver: Type: OracleException Message: ORA-01756: quoted string not properly terminated Call Stack: at .c (Int32 A0) at 9.a (String A0) at .InternalPrepare (Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords) at. 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. Cause: You tried to execute a statement that contained a string that was not surrounded by two single quotes. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |