oracle - Dynamic SQL - Check syntax and semantics -

-

with oracle dynamic sql 1 able execute string containing sql statement. e.g.

l_stmt := 'select count(*) tab1'; execute immediate l_stmt;

is possible not execute l_stmt check syntax , semantics correct programmitically?

i think "solution" use dbms_sql.parse().

it not perfect best can get


Comments

Post a Comment

Popular posts from this blog

python - Setting ctypes.Structure default values -

-
this doesn't work: class ifinfomsg(ctypes.structure): _fields_ = [ ('ifi_family', ctypes.c_ubyte), ('__ifi_pad', ctypes.c_ubyte), ('ifi_type', ctypes.c_ushort), ('ifi_index', ctypes.c_int), ('ifi_flags', ctypes.c_uint), ('ifi_change', ctypes.c_uint(0xffffffff)) ] it errors with: file "rtnetlink.py", line 243, in <module> class ifinfomsg(ctypes.structure): typeerror: error when calling metaclass bases second item in _fields_ tuple (index 5) must c type however can set values in __init__() : class ifinfomsg(ctypes.structure): _fields_ = [ ('ifi_family', ctypes.c_ubyte), ('__ifi_pad', ctypes.c_ubyte), ('ifi_type', ctypes.c_ushort), ('ifi_index', ctypes.c_int)...
Read more

Ansible - ERROR! the field 'hosts' is required but was not set -

-
i've error when launch playbook don't found why.... error! field 'hosts' required not set there main.yml : --- - hosts: hosts - vars: - elasticsearch_java_home: /usr/lib/jmv/jre-1.7.0 - elasticsearch_http_port: 8443 - tasks: - include: tasks/main.yml - handlers: - include: handlers/main.yml and /etc/ansible/hosts : [hosts] 10.23.108.182 10.23.108.183 10.23.108.184 10.23.108.185 when test ping, : [root@poste08-08-00 elasticsearch]# ansible hosts -m ping 10.23.108.183 | success => { "changed": false, "ping": "pong" } 10.23.108.182 | success => { "changed": false, "ping": "pong" } 10.23.108.185 | success => { "changed": false, "ping": "pong" } 10.23.108.184 | success => { "changed": false, "ping": "pong" } please, me :) regards, you have syntax error in playbook. ...
Read more

java - HTTP Status 500 - No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode -

-
i know question has been asked lot of times. have searched entire stack overflow, haven't been able out of it. understand exception arises when column name used in query different property specified in bean class, however, both of parameters same. complete error: java.lang.illegalstateexception: no data type node: org.hibernate.hql.internal.ast.tree.identnode +-[ident] identnode: 'iduserinfo' {originaltext=iduserinfo} this query: list<object[]> tuples = session.createquery( "select iduserinfo, sum(points) " + persistentclass.getname() + " group iduserinfo " + "order sum(points) desc").list(); and bean class: @xmlrootelement @entity @table(name = "userinfo") public class userinfo { protected @xmlelement int id; protected @xmlelement int iduserinfo; protected @xmlelement int idquestion; protected @xmlelement string location; protected @xmlelement string state; protected @xmlelement stri...
Read more