Toad World® Forums

Toad 11.5 - PLSQL compiler warnings?

Hello all,

I’m using Toad 11.5 on an Oracle 11gR2 database, and trying to find how to get pl/sql compiler warnings when compiling a procedure/package/function. I cannot find it, is there an option in Toad to turn this on?

Looking for the Toad equivalent of ‘alter session set plsql_warnings=‘ENABLE:ALL’’

And, off topic: is there a way to search this forum?

In PL/SQL editor mod (same tab):

set serveroutput on size 123456;

ALTER SESSION SET PLSQL_WARNINGS=‘ENABLE:ALL’;

drop table a;

create table a ( b number);

create or replace procedure plw_07204 (p_rwid urowid)
authid DEFINER
is
l_i number;
begin
select b
into l_i
from a
where rowid = p_rwid;
end;
/

show errors;

and result (messages output) is:
Session altered.
Table dropped.
Table created.
Procedure created.
Errors for PROCEDURE PLW_07204

LINE/COL ERROR


9/21 PLW-07204: conversion away from column type may result in sub-opt
imal query plan

More you can find on:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:637694300346290510

Rg Damir