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.
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.
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
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 :=
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
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
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
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
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
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
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
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 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 . 10 times in last 20 mins Grrrr. updates all up to date."...updates all up to date" Well there you go.
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
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
Hi All, I am settting Oracle SOA suite 126.96.36.199 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
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: 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
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