Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Expanding text of Macro with domain

Mike KutzFeb 9 2024

I'm trying to debug an SQL Macro that generates code that use domains and domain_check() and domain_check_type()

  • dbms_output.put_line() (within the function) shows that the generated statement is correct and the results are correct
  • select * from macro() compiles but shows the incorrect results
  • dbms_utility.expand_sql_text() results in a statement that throws “ORA-00907: missing right parenthesis”
    • This seems to be due to the expanded text using functions domain_chek() and domain_chek_type()
This post has been answered by Chris Saxon-Oracle on Feb 13 2024
Jump to Answer
Comments
Post Details
Added on Feb 9 2024
6 comments
98 views