Re: [External] : sqlplus set feedback ONLY questions when hitting 12.1 database

This might have been a stupid question actually because I realize I mixed some thoughts (I blame it on a bad headache)

I was thinking about a pl/sql script that executes a SQL statement so there's no output returned to the screen - in *that *case, there's no fetch done.

Such as:

declare
v_sql clob;
begin
select sql_text from dba_hist_sqltext into v_sql where sql_id = 'xxxxxxxx'; execute immediate v_sql ;
end;
/

That pl/sql executes the sql text, but doesn't perform a fetch - which is what I was thinking of if rows weren't returned to the calling client.

I should log off and go rest my head.

Chris

On Mon, Jun 27, 2022 at 2:07 PM Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> Go grab SQLcl…those are client side things, db version doesn’t matter.
>
>
>
>
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Chris Taylor
> *Sent:* Monday, June 27, 2022 1:53 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* [External] : sqlplus set feedback ONLY questions when hitting
> 12.1 database
>
>
>
> So a Dev just sent me a query to work on where he's using SET FEEDBACK
> ONLY - so I had to look it up.
>
>
>
> The problem is, he's using a 19c sqlplus client connected to a 12.1
> database where FEEDBACK ONLY wasn't available.
>
>
>
> So I'm curious and haven't traced it [yet] , doesn't anyone know what the
> database does in this case?
>
> I'm imagining that in 12.1 it will skip the FETCH (because FEEDBACK ONLY
> wasn't available) whereas in 12.2 and above the database will perform the
> FETCH.
>
> Does anyone know? (Before I trace it myself - I don't want to answer a
> question for myself that someone else already knows)
>
> Chris
>
>
>

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image001.png