Skip to main content
Solved

Can InlineQuerier understand PL/SQL?

  • November 29, 2016
  • 6 replies
  • 22 views
michael_m
Participant
Forum|alt.badge.img+1

I am currently using an SQL statement in an InlineQuerier. It's been working fine until recently but I have run across a situation in my data that I did not expect and now I need to throw a bit more logic at it. A coworker suggested PL/SQL.

Can the InlineQuerier understand PL/SQL statements?

Best answer by erik_jan

If you build a PL/SQL stored function you can embed that function in a SQL statement and the InlineQuerier passes that on to your Oracle database.

The other option is using the SQLExecutor. I believe that transformer allows execution of PL/SQL blocks.

View original
Did this help you find an answer to your question?

6 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • Best Answer
  • November 29, 2016

If you build a PL/SQL stored function you can embed that function in a SQL statement and the InlineQuerier passes that on to your Oracle database.

The other option is using the SQLExecutor. I believe that transformer allows execution of PL/SQL blocks.

michael_m
Participant
Forum|alt.badge.img+1
  • michael_mParticipant
  • Author
  • Participant
  • November 29, 2016
erik_jan wrote:

If you build a PL/SQL stored function you can embed that function in a SQL statement and the InlineQuerier passes that on to your Oracle database.

The other option is using the SQLExecutor. I believe that transformer allows execution of PL/SQL blocks.

My understanding from reading through documentation is that SQLExecutor can only be used on an Oracle database. In my case there is no database, just the data flowing through my .fmw (what name do people typically use for an .fmw file anyway?). Do you still think I could package up a some PL/SQL as you suggest and have it work?
erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • November 29, 2016
michael_m wrote:
My understanding from reading through documentation is that SQLExecutor can only be used on an Oracle database. In my case there is no database, just the data flowing through my .fmw (what name do people typically use for an .fmw file anyway?). Do you still think I could package up a some PL/SQL as you suggest and have it work?
Hi @michael_m,

 

PL/SQL is only available for Oracle.

 

This is the Wikipedia definition:

 

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

 

So without an Oracle database, you will not be able to use PL/SQL

 

michael_m
Participant
Forum|alt.badge.img+1
  • michael_mParticipant
  • Author
  • Participant
  • November 29, 2016
erik_jan wrote:
Hi @michael_m,

 

PL/SQL is only available for Oracle.

 

This is the Wikipedia definition:

 

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

 

So without an Oracle database, you will not be able to use PL/SQL

 

 

Thank you for your help!
david_r
Evangelist
  • david_rEvangelist
  • November 30, 2016
erik_jan wrote:

If you build a PL/SQL stored function you can embed that function in a SQL statement and the InlineQuerier passes that on to your Oracle database.

The other option is using the SQLExecutor. I believe that transformer allows execution of PL/SQL blocks.

@erik_jan, can you explain what you mean by: "If you build a PL/SQL stored function you can embed that function in a SQL statement and the InlineQuerier passes that on to your Oracle database."

 

 

It was my understanding that the InlineQuerier is wholly based on SQLite and that it does not have any integration with other databases such as Oracle. Or have I missed some interesting functionality?

 

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • November 30, 2016
david_r wrote:
@erik_jan, can you explain what you mean by: "If you build a PL/SQL stored function you can embed that function in a SQL statement and the InlineQuerier passes that on to your Oracle database."

 

 

It was my understanding that the InlineQuerier is wholly based on SQLite and that it does not have any integration with other databases such as Oracle. Or have I missed some interesting functionality?

 

@david_r You are right. PL/SQL can not be used in combination with the InlineQuerier as it is not connected to an Oracle database.

 

Reply


Helpful Members This Week

Community Stats

30,915
Posts
117,136
Replies
38,719
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.