PLW-07204 Warning

Advertisement
We are using SQLDeveloper and almost every stored procedure I compile I get this warning. If I had it my way, I would not use SQLDeveloper but due to budget restrictions this is all I have.
Here is the piece of code I am getting this warning on.
select count(*)
into dup_cnt
FROM trans
WHERE trans.ID_SSN = SSN_NUM
AND trans_cd = 'DU'
and trans_date between '01-NOV-'||to_char(to_number(to_char(sysdate,'YYYY')-1)) and trunc(sysdate);
Thank you for taking time to look at this.
Sandeep.
Advertisement

Replay

I don't get any errors compiling it (in SQL*Plus or
SQLDeveloper) these are only warnings, but would like
not to get any warnings.did you get any warning message when you tried to recompile it in SQL*Plus?
i think it might have been because your start range is ahead of end range. if your 01-NOV is always fixed you need to define some mechanism that would allow your code to use the current year or prior year if the current month is not yet in november or ahead of november which is in december.
  decode(to_char(sysdate,'MON'),'NOV', to_date('01-NOV-'||to_char(sysdate,'YYYY'),'DD-MON-YYYY'),
                                'DEC','to_date('01-NOV-'||to_char(sysdate,'YYYY'),'DD-MON-YYYY'),
                                to_date('01-NOV-'||to_char(to_number(to_char(sysdate,'YYYY'))-1),'DD-MON-YYYY'))

PLSQL warning

Hi All, I have compiled a procedure which contains the below query, is giving the below warning...Can any one help me to get out of this issue... Warning(6,3): PLW-07204: conversion away from column type may result in sub-optimal query plan SELECT co

Compiler warning PLW-05003 parameter at IN and COPY may have side effects

For the following Procedure: create or replace PROCEDURE lob_replace p_lob IN OUT NOCOPY CLOB, p_what IN VARCHAR2, p_with IN VARCHAR2 ) AS n NUMBER; BEGIN dbms_output.put_line('p_what = ' || p_what); dbms_output.put_line('p_with = ' || p_with); n :=

No warning message triggered for VP

Hi, I need help from the experts. I have set tolerance limit for VP at SPRO > Materials Management > Inventory Management and Physical Inventory > Goods Receipt > Set Tolerance Limits I have also changed the system messages at SPRO > Materi

When trying to view my pics in full screen size a warning sign appears

In IPhoto I click on the thumbnail photos and I get a triangular warning sign and no photo.  This happened with the original operating system and newly downloaded version as well as new IPhoto.   Consistently does not function!   Suggestions?The ! tu

How to change P.O. duplication message type from warning to error for Order

Hi Experts, I have a requirment to change P.O. duplication message type from warning to error for Order only not OrderTemplate.  I can easily change message type in BAdI ISA_BASKET_MSGS, but I can't find the parameter to know if it's Order or OrderTe

Warning Messages - Hotsync

I keep getting this warning message in my hotsync log.  I don't know what to do about it.  can anyone point me in the right direction? -- WARNING: Possible database overwrite problem. Backing up database usa_and_canada-08c39cd5.mac to file C:\Program

EMail Submit Button - Javascript warning

On Friday, my distributed pdf worked perfectly. On Monday, when selecting the "Submit by eMail" button, it generates a javascript warning which then requires the user to fill out all of the senders email information and go through several warnin

IDOC Process Stops Due To System Warning

Hello Friends, Here is the ALE inbound scenario: We are setting up an order BOM interface using idoc BOMORD01. During the test, we found that the idoc has the error status 51 and this was due to a warning message issued by the system. In dialog mode

Temperature Warning with Charging

Everytime I plug my ipod in to charge it, it comes up with a temperature warning. Ive tried different chargers and the same thing happens. How can I get it to charge normally again? It doesnt even feel hot but it wont stop. Anything i can do other th

MSI Z87MPOWER MAX and weird warning

I played with my samsung 840 pro and i turned RAPID mode off. Computer needed restart, and when i come back to system i get this warning : You are not using the first BIOS ROM currently. MSI strongly recommend you to update your BIOS via MSI Live upd

ITunes 6.02 Warning ???

Hi! I've just updated my Swedish iTunes to 6.02 When i restart i get a message: (translated) "Warning! Registersettings for burning CD- and DVD-discs are missing. This may occour when you install other CD-burning programs. Reinstall iTunes!" Whe

Hi, I am getting a warning message on screen, saying that my iPad hasn't been backed up for 2 weeks, and saying under what circumstances the message appears. My problem is, is that I have backed up iCloud, but am unable to remove the warning.

Hi, I am getting a warning message on screen, saying that myiPad hasn't been backed up to iCloud for two weeks, and advising under what circumstances the message appears. My problem is, is that I have backed it up, but am unable to remove the message

So without warning while surfing with Safari, it will just close? I haven't been able to pin it to a certain action, but it does it regularly . It...

So without warning while surfing with Safari, it will just close? I haven't been able to pin it to a certain action, but it does it regularly . 10 times in last 20 mins Grrrr. updates all up to date."...updates all up to date" Well there you go.

WARNING: SCOSMB failed to load

Hi I installed solaris 10 in 1 domain from a sunfire25k, this is composed by 2 IO Boards and 1 SB, I used a solaris 10 jumpstart and everything was ok trough the instalation, but after that, when domain reboots to start de SO. apears the next error a

"Warning: compiled but with compilation errors" while executing procedure.

Hi All, i am so new to plsql. this code has been compiled but it gave a warning. I guess i am missing a small issue like semicolon but since im new i could not see what the problem is. CREATE OR REPLACE procedure BAKIM.grantt_uguser as cursor synn is

SOA managed server warning

Hi All, I am settting Oracle SOA suite 11.1.1.4 in solaris environment. All components are set up successfully like DB, RCU, Weblgic and SOA suite installation. When I am starting the soa_server1 managed server using NM I am getting following as WARN

Forcing a Truncation warning in string to be error

Hi, If let say my source table has column with varchar(20) and my destination table has a column of varchar(5), I want SSIS to force to an error because of the truncation detected. Is it possible? Currently, warning is shown at design time that there

Warning for Ivy Bridge

Warning: If you are considering a system based on the Ivy Bridge processor, be warned that the cooling paste Intel uses on the Ivy Bridge is no good, especially when overclocking. At stock speed the i7-3770K runs 11 degrees hotter than with CoolLabor

Won't show CF card, yet it gives me device removal warning when I pull it.

This happens occasionally and I don't know why. I put in a disc and it does not show in the finder under devices or anywhere else I can find. I pull the disc, and it gives the the device removal warning. It it's reading it, then where the heck am I s