• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

PL/SQL PRogramming (Urgent)

 
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I would like to know how I can compile my PL/SQL
program.Is there any tools that I can use?
Thanks,
Samira
 
Ranch Hand
Posts: 336
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes,
Get Toad you will never regret it
 
Samira Mastali
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you.I get probem for the following stored procedure during the execution:
CREATE OR REPLACE procedure procCopsCircuitOraclestatement
(
Form_name varchar,
Object_ID varchar,
Action_Name varchar,
Circuit_Number varchar,
Location_A varchar,
Location_B varchar,
Customer_Name varchar,
Ts_Code varchar,
TC_Name varchar,
SC_Name varchar,
Customer_ID varchar,
COPS_Customer_Code varchar)
is

BEGIN -- executable part starts here

--Inventory_Item_Type CONSTANT CHAR(7) := 'CIRCUIT';

begin
CASE Action_Name

WHEN 'add' THEN

SELECT CUSTOMERID, TC from Service where CUSTOMERID = Customer_ID and TC = TC_Name;

--IF !

INSERT INTO Service (CustomerID, TC) VALUES (Customer_ID, TC_Name);
--END IF;

INSERT INTO InventoryItem

(InventoryEntryID, InventoryItemID , InventoryItemType, Action, LOCNA,LOCNZ,SC, CustomerID,COPSTMCustomerCode)
VALUES
(Object_ID, Circuit_Number, Inventory_Item_Type, Action_Name, Location_A ,Location_B ,SC_Name, Customer_ID,COPS_Customer_Code);

INSERT INTO ServiceItem

(CustomerID, TC, LineItem, LineItemType, LineItemData)
VALUES
(Customer_ID, TC_Name, Object_ID, Inventory_Item_Type, Circuit_Number);

INSERT INTO ServiceInventory
(CustomerID, TC, InventoryItemID, InventoryEntryID)
VALUES
(Customer_Num, TC_Name, Circuit_Number, Object_ID);

WHEN 'delete' THEN
Delete InventoryItem where InventoryEntryID = Object_ID and InventoryItemID = Circuit_Number;

Delete ServiceInventory where InventoryEntryID = Object_ID and InventoryItemID = Circuit_Number;

Delete ServiceItem where LineItem = Object_ID and LineItemData = Circuit_Number;

WHEN 'change' THEN

SELECT CUSTOMERID, TC from Service where CUSTOMERID = Customer_ID and TC = TC_Name;
--IF !
update Service set customerID = customer_ID;
--END IF;
update InventoryItem set InventoryEntryID = Object_ID, InventoryItemID = Circuit_Number , Action = Action_Name , LoCNA = Location_A ,
LOCNZ = Location_Z , CustomerID = Customer_ID , COPSTMCustomerCode = COPS_Customer_Code
where InventoryEntryID = Object_ID and InventoryItemID = Circuit_Number;

update ServiceItem set LineItem = Object_ID, LineItemType = Inventory_Item_Type, LineItemData = Circuit_Number
where LineItem = Object_ID and LineItemData = Circuit_Number;

update ServiceInventory set InventoryEntryID = Object_ID, InventoryItemID = Circuit_Number
where InventoryEntryID = Object_ID and InventoryItemID = Circuit_Number;

COMMIT;
END CASE Action_Name;
end;
/*
EXCEPTION -- exception-handling part starts here
WHEN comm_missing THEN
*/
END procCopsCircuitOraclestatement;
/
I don't know what is the problem.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Did you do "show errors"? to find out what the error is.
What you posted is like saying, this here is my haystack, I dropped something small in it, like a needle, but not necessarily a needle. Now Go Git It!
Are you using Toad? you can step through your code in Toad (heh it rhymes) and find out which line has the error.
Mark
 
Samira Mastali
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks.
Yes, I am using Toads.it is giving a nonsense message.For example when I put the declare statement it complains about that.
Also I get the following error on my variable declaration:
PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "VARCHAR2" to continue.
 
reply
    Bookmark Topic Watch Topic
  • New Topic