H$$r$,$ I$\text{'}$m assuming that $`\text{'}$Cat$$gory$1\text{'}`$ and $`\text{'}$Cat$$gory$2\text{'}`$ ar$$xampl$$ cat$$gory nam$$s you want to ins$$rt into th$`$Cat$$gori$$s$`$ tabl$.$ You can r$$plac$$ th$$s$$ with th$$ nam$$s you want to t$$st$.$

R$$m$$mb$$r$,$ you'll n$$d th$$ appropriat$$ p$$rmissions to cr$$at$$ proc$$dur$$s and $$x$$cut$$ th$$m in your Oracl$$ databas$.$ Also, $$nsur$$ that your tabl$$ structur$$ match$$s th$$ provid$$d cod$($i$..,$ a tabl$$ nam$$d $`$Cat$$gori$$s$`$ with a column $`$cat$$gory$\_$nam$`).$

Explanation:

$1.$ Cr$$ating th$$ Stor$$d Proc$$dur$`$ins$$rt$\_$cat$$gory$`$

$```$sql

CREATE OR REPLACE PROCEDURE ins$$rt$\_$cat$$gory$($

p$\_$cat$$gory$\_$nam$$ IN VARCHAR$2$

$)$ AS

BEGIN

INSERT INTO Cat$$gori$$s$($cat$$gory$\_$nam$)$

VALUES $($p$\_$cat$$gory$\_$nam$)$;

COMMIT;

EXCEPTION

WHEN DUP$\_$VAL$\_$ON$\_$INDEX THEN

DBMS$\_$OUTPUT. PUT$\_$LINE$(\text{'}$Duplicat$$ cat$$gory nam$.$ Cannot ins$$rt$.\text{'})$;

END;

$/$

$```$

$-`$CREATE OR REPLACE PROCEDURE$`$: This stat$$m$$nt cr$$at$$s a n$$w stor$$d proc$$dur$$ nam$$d $`$ins$$rt$\_$cat$$gory$`.$ Th$`$OR REPLACE$`$ claus$$ allows you to modify th$$ proc$$dur$$ if it alr$$ady $$xists without causing an $$rror$.$

$-`$ins$$rt$\_$cat$$gory$`$: This is th$$ nam$$ of th$$ proc$$dur$.$

$-`$p$\_$cat$$gory$\_$nam$$ IN VARCHAR$2`$: This lin$$ d$$fin$$s a param$$t$$r for th$$ proc$$dur$.$ It $$xp$$cts a VARCHAR$2$ input param$$t$$r nam$$d $`$p$\_$cat$$gory$\_$nam$`.$

Insid$$ th$$ Proc$$dur$$:

$-`$BEGIN$`$ and $`$END$`$: Th$$s$$ d$$limit th$$ body of th$$ proc$$dur$.$

$-`$INSERT INTO Cat$$gori$$s$($cat$$gory$\_$nam$)$ VALUES $($p$\_$cat$$gory$\_$nam$)`$: This lin$$ p$$rforms th$$ actual ins$$rtion into th$`$Cat$$gori$$s$`$ tabl$.$ It us$$s th$$ input param$$t$$r $`$p$\_$cat$$gory$\_$nam$`$ to ins$$rt a n$$w row into th$$ tabl$.$

$-`$COMMIT$`$: Commits th$$ transaction, making th$$ chang$$s p$$rman$$nt$.$

$-`$EXCEPTION WHEN DUP$\_$VAL$\_$ON$\_$INDEX THEN$`$: This block handl$$s th$$xc$$ption that occurs wh$$n trying to ins$$rt a duplicat$$ valu$$ into th$$ tabl$.$ It catch$$s th$`$DUP$\_$VAL$\_$ON$\_$INDEX$`$xc$$ption$,$ which happ$$ns wh$$n a uniqu$$ constraint is violat$$d $($in this cas$,$ th$$ duplicat$$ cat$$gory nam$).$

T$$sting th$$ Proc$$dur$$:

$```$sql

BEGIN

ins$$rt$\_$cat$$gory$(\text{'}$Cat$$gory$1\text{'})$;

END;

$/$

$```$

$-`$BEGIN$`$ and $`$END$`$: This signifi$$s th$$ b$$ginning and $$nd of an anonymous PL$/$SQL block.

$-`$ins$$rt$\_$cat$$gory$(\text{'}$Cat$$gory$1\text{'})`$: Calls th$`$ins$$rt$\_$cat$$gory$`$ proc$$dur$$ and att$$mpts to ins$$rt th$$ cat$$gory nam$`\text{'}$Cat$$gory$1\text{'}`$ into th$`$Cat$$gori$$s$`$ tabl$.$

Th$$ s$$cond t$$st:

$```$sql

BEGIN

ins$$rt$\_$cat$$gory$(\text{'}$Cat$$gory$2\text{'})$;

END;

$/$

$```$

$-$ Similar to th$$ first t$$st$,$ this block calls th$`$ins$$rt$\_$cat$$gory$`$ proc$$dur$,$ trying to ins$$rt th$$ cat$$gory nam$`\text{'}$Cat$$gory$2\text{'}`.$

Output for Duplicat$$ Cat$$gory Nam$$:

If th$$ proc$$dur$$ncount$$rs a duplicat$$ cat$$gory nam$$ during ins$$rtion$,$ it will not ins$$rt th$$ duplicat$.$ Inst$$ad$,$ it will $$x$$cut$$ th$`$DBMS$\_$OUTPUT. PUT$\_$LINE$(\text{'}$Duplicat$$ cat$$gory nam$.$ Cannot ins$$rt$.\text{'})$;$`$ lin$,$ which will display a m$$ssag$$ indicating that a duplicat$$ nam$$ was att$$mpt$$d to b$$ ins$$rt$$d$.$

Pl$$as$$ mak$$ sur$$ you hav$$ th$$ n$$c$$ssary privil$$g$$s to cr$$at$$ proc$$dur$$s and $$x$$cut$$ th$$m in your Oracl$$ databas$.$ Adjust th$$ tabl$$ and column nam$$s accordingly to match your databas$$ sch$$ma$.$