473,323 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

code explaination

create or replace
PROCEDURE in_focus_page
(ldt portal_home_non_login_log.logdatetime%TYPE,
COT portal_home_non_login_log.counter%TYPE)

IS
BEGIN
INSERT
INTO infocus_log
VALUES
((sysdate) ,COT);
DBMS_OUTPUT.PUT_LINE('RECORD IS ADDED......!');
COMMIT;
END in_focus_page;


Can anyone explain to me what the bold part is about?
Jul 3 '07 #1
1 1107
debasisdas
8,127 Expert 4TB
In the code

ldt portal_home_non_login_log.logdatetime%TYPE,
COT portal_home_non_login_log.counter%TYPE

both the variables idt and cot are %type variables.

it means what ever is the field type of logdatetime field in the portal_home_non_login_lo table the parameter is of that type.

for ex
if it is number then it will be of same type.
or
if it is varchar2 then it wiill be varchar2


this is used to avoid data type mismatch in the formal parameter and actual parameter.
Jul 3 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Wayne... | last post by:
I'm trying to make a sort of source code libary for some customers of commonly used code to save them a bit of time the problem I have is that although I can get the asp code into a field of an...
7
by: Douglas Buchanan | last post by:
I cannot access certain column values of a list box using code. I have a list box 'lstPrv' populated by the query below. SELECT tblPrv.fkPrvID, lkpCat.CatNm, lkpSrv.SrvNm, lkpCat.pkCatID,...
20
by: vb | last post by:
hi all, I have to compare an address of structure with an absolute address(this address signifies the start of a memory component). Now my question is the follwong code leagal:- #include...
192
by: Vortex Soft | last post by:
http://www.junglecreatures.com/ Try it and tell me what's happenning in the Microsoft Corporation. Notes: VB, C# are CLS compliant
2
by: Steve B. | last post by:
In the following code snipet, what does this code do? Where does it return a bool to... OS? Does it import a User32.dll library? The code is part of creating a singleton instance of an...
1
by: HMANG | last post by:
I have a c# application that calls a mixed code dll which in turn calls an unmanaged dll that has an inline template class constructor. The c# application runs fine until I use it on IIS The...
2
by: Phoe6 | last post by:
Hi all, I have this Code Context feature under Options in the IDLE. How should I use it? Are there folks here who use it regularly and find it useful. Please guide me. Thanks! Senthil
3
by: Groove | last post by:
This might be fairly easy to do. Hopefully, it is. (asp.net 2 / vb) I have a Drop Down List and in th code-behind vb file, I'd like to optionally add a OnSelectedIndexChanged attribute to it....
0
by: Joe | last post by:
Hi Could someone give me a simple explaination of this XSD which is a DataSet with relations The tables are fgFAT,e0,e1,e2,e3 which I have deleted I am trying to make sense of the part below...
44
by: shuisheng | last post by:
Dear All, Assume there are three classes where CA has members of class CA1 and CA2 as follows. To make the public functions of CA1 and CA2 can work on the members a1 and a2 in a CA object, I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.